sign-ssis-expression.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords
SIGN (SSIS Expression)	SIGN (SSIS Expression)	chugugrace	chugu	03/01/2017	sql	integration-services	conceptual	positive values [Integration Services] SIGN function negative values

SIGN (SSIS Expression)

[!INCLUDEsqlserver-ssis]

Returns the positive (+1), negative (-1), or zero (0) sign of a numeric expression.

Syntax

  
SIGN(numeric_expression)  

Arguments

numeric_expression
Is a valid signed numeric expression. For more information, see Integration Services Data Types.

Result Types

DT_I4

Remarks

SIGN returns a null result if the argument is null.

Expression Examples

This example returns the sign of a numeric literal. The return result is -1.

SIGN(-123.45)  

This example returns the sign of the result of subtracting the StandardCost column from the DealerPrice column.

SIGN(DealerPrice - StandardCost)  

See Also

Functions (SSIS Expression)