SIGN function The SIGN function returns the sign of the specified number. SIGN functionfunctionsSIGN

The specified number is the number you want the sign of. The specified number must be a DOUBLE PRECISION number.

The data type of the returned value is INTEGER.

  • If the specified number is NULL, the result of this function is NULL.
  • If the specified number is zero (0), the result of this function is zero (0).
  • If the specified number is greater than zero (0), the result of this function is plus one (+1).
  • If the specified number is less than zero (0), the result of this function is minus one (-1).
SyntaxSIGN ( number )