abs-ssis-expression.md

title	ABS (SSIS Expression)
description	ABS (SSIS Expression)
author	chugugrace
ms.author	chugu
ms.date	03/01/2017
ms.service	sql
ms.subservice	integration-services
ms.topic	concept-article
helpviewer_keywords	ABS function absolute positive value

ABS (SSIS Expression)

[!INCLUDEsqlserver-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.

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 LowTemperature.

ABS(@HighTemperature - @LowTemperature)  

See Also

Functions (SSIS Expression)