SQL Server/T-SQL/Math Functions/SIGN
SIGN: return a -1 if the number is negative, +1 if the number is positive, or 0 if the number is 0
<source lang="sql">
2> -- SIGN: return a -1 if the number is negative, +1 if the number is positive, or 0 if the number is 0. 3> 4> SELECT SIGN(-23) 5> GO
-1
(1 rows affected)
</source>