ABS (SSIS Expression)
Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory
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.
Expression 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)
See Also
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for