ABS (SSIS)
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)