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);