The SIGN() function returns the sign of "Number" as -1, 0, or 1, depending on whether the value of "Number" is negative, zero, or positive.
If the value of "Number" is not numeric, an attempt is made to cast it to a numeric type before evaluating the sign.
SIGN() returns NULL if the value of "Number" is NULL. |