ABS() - Absolute value

Function group: numeric function

ABS() determines the absolute value of a numeric value.

---

ABS ( expression )

---

expression

Numeric expression.
expression may not be a multiple value with dimension > 1.

Result

When expression returns the NULL value, the result is the NULL value.

Otherwise: the absolute value of expression. In other words the value of expression when expression is positive, otherwise the value of -(expression).

Data type: like expression

Examples

ABS (3,14) returns the value 3,14.

ABS (-3,14) returns the value 3,14.