ABS or ABSVAL

ABS or ABSVAL returns the absolute value of a numeric expression. The return type is the type of parameter. All built-in numeric types are supported (DECIMAL, DOUBLE PRECISION, FLOAT, INTEGER, BIGINT, NUMERIC, REAL, and SMALLINT).

Syntax

ABS(NumericExpression)

Example

-- returns 3
VALUES ABS(-3)