ABS: Returning an Absolute Value (SQL)

How to:

The ABS function returns the absolute value of a number.


Top of page

x
Syntax: How to 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.



Example: Returning an Absolute Value

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

ABS(-5.5)

returns 5.5.


iWay Software