ABS (SSIS Expression)

ABS (SSIS Expression)

 

Applies To: SQL Server 2016 Preview

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)

Community Additions

ADD
Show:
© 2016 Microsoft