The SIGN Function
Syntax for the SIGN function:
numeric-value is an integer or a float value expression.
Rules:
- The function returns an indicator of the sign of numeric-value. If numeric-value is less than zero, -1 is returned. If numeric-value equals zero, 0 is returned. If numeric-value is greater than zero, 1 is returned.
- If the value of numeric-value is NULL, then the result of the function is NULL.
