Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the absolute, positive value of a numeric expression.
Syntax
ABS(numeric_expression)
Arguments
- numeric_expression
Is a signed or unsigned numeric expression.
Result Types
The data type of the numeric expression submitted to the function.
Remarks
ABS returns a null result if the argument is null.
Examples
These examples apply the ABS function to a positive and a negative number. Both return 1.23.
ABS(-1.23)
ABS(1.23)
This example applies the ABS function to an expression that subtracts values in the variables HighTemperature and LowTempature.
ABS(@HighTemperature - @LowTemperature)