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