SIGN function

The SIGN function returns an indicator of the sign of the argument.

SIGN Function

1  SIGN ( expression )

If the argument is less than zero, -1 is returned. If the argument equals zero, 0 is returned. If the argument is greater than zero, 1 is returned. The result returned is always an integer with one of these values.