Returns the absolute value of a numeric expression.
ABS( numeric-expression )
numeric-expression The number whose absolute value is to be returned.
An absolute value of the numeric expression.
INT
FLOAT
DOUBLE
NUMERIC
SQL/2008 The ABS function is part of optional SQL/2008 language feature T441.
The following statement returns the value 66.
SELECT ABS( -66 );