SIGN(a) is an arithmetic function that provides information about the sign of the expression a (a number).
|
Result of the SIGN(a) Function |
a<0 |
-1 |
a=0 |
0 |
a>0 |
1 |
a is the NULL value |
NULL value |
a is a special NULL value |
Special NULL value |