ABS: Returning an Absolute Value (SQL)

The ABS function returns the absolute value of a number.

Return an Absolute Value

ABS(arg)

where:

arg

Numeric

Is the input value.

This function returns the value as the same data type as the argument. For example, if the argument is an integer, the result will be also be an integer.

Returning an Absolute Value

ABS returns the absolute value of a number. This example, 

ABS(-5.5)

returns 5.5.