Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
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
The following statement returns the value 66:
66
SELECT ABS( -66 );
Syntax