Syntax
ABSOLUTE_VALUE(Argument)
Description
The ABSOLUTE_VALUE SQL scalar function returns the absolute value of a number.
The argument must be a number.
The data type and length attribute of the result are the same as the data type and length attribute of the argument value, except that the result is a large integer if the argument value is a small integer.
If the argument can be null, the result can be null; if the argument is null, the result is the null value.
Example
Assume the column PROFIT is a large integer with a value of -50000.
ABSOLUTE_VALUE(PROFIT)
Returns the value 50000.
List of SQL scalar functions by topic