| ANSI | DB2 | SQL/DS | XDB |
|---|---|---|---|
| X |
Returns the sign of the parameter expr. The format appears below:
SIGN(expr)
A value of one is returned if expr is positive, and a value of zero is returned if expr is zero, and -1 is returned if expr is negative. For example:
SIGN(-234.4) = -1 SIGN(234) = 1 SIGN(0) = 0