SqlExpression ABS

From Eigenpedia

Contents 1 Syntax 2 Purpose 3 Input 4 Output 5 Example

Syntax

ABS( numeric_expression )

Purpose

Returns the absolute value of a numeric expression

Input

• numeric_expression - number to get absolute value of

Output

• [NUMERIC] - absolute value of numeric_expression. Returns null on null input.

Example

Function	Result
ABS(cast(-123 as TINYINT))	123
ABS(54.34)	54.34
ABS(-9.32E-2)	0.932

---

Return to Built in Function details