title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | ||
---|---|---|---|---|---|---|---|---|---|---|
ABS (SSIS Expression) |
ABS (SSIS Expression) |
chugugrace |
chugu |
03/01/2017 |
sql |
integration-services |
conceptual |
|
[!INCLUDEsqlserver-ssis]
Returns the absolute, positive value of a numeric expression.
ABS(numeric_expression)
numeric_expression
Is a signed or unsigned numeric expression.
The data type of the numeric expression submitted to the function.
ABS returns a null result if the argument is null.
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)