ABS
Syntax
ABS (numeric_expression)
Description
Finds the value of a numeric expression without regard to its sign.
Arguments
numeric_expression | A number that can be converted to a Double64 number. |
Returns
A positive numeric value in Double64 format. A Double32 or Double64 data type represents a 32- or 64- double-byte floating-point number.
Remarks
Using ABS with Decimal data greater than 64 bits may result in a loss of precision.
Decimal (128) data type is a decimal number with a maximum length of 128 bits.
Note: Many functions return a numeric value smaller than the maximum length of decimal. If your data is longer than 32 bits, make sure you understand what the return value is. Any extra digits are truncated.
Examples
ABS ( -17 )
and ABS ( 17 )
Both return:
17