Link Search Menu Expand Document

ABS

Calculates the absolute value of a number <val>.

Syntax 

ABS(<val>)
Parameter Description
<val> Valid values include column names, functions that return a column with numeric values, and constant numeric values.

Example 

SELECT
    ABS(-200.50);

Returns: 200.5