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