SIGN

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

Syntax

SIGN ( numeric_expression )

Arguments

_numeric_expression_

Is an expression of the exact numeric or approximate numeric data type category, except for the bit data type.

Return types

Specified expression Return type
bigint bigint
int/smallint/tinyint int
money/smallmoney money
numeric/decimal numeric/decimal
Other types float

Examples

SELECT SIGN(2.01);

See Also