Returns a value indicating the sign of an expression.
SGN(numeric_expression)
numeric_expression is any numeric expression. If the value of the expression is positive, SGN returns 1. If the value is negative, SGN returns -1. If the value is 0, SGN returns 0.
PRINT SGN(-3)
PRINT SGN(0)
PRINT SGN(127)
Results in:
-1
0
1