Share via


SIGN (SSIS Expressions)

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

Syntax

SIGN(numeric_expression)

Arguments

Result Types

DT_I4

Remarks

SIGN returns a null result if the argument is null.

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

Other Resources