Nulls and Arithmetic Operators and Functions
If an operand of any arithmetic operator or function is null, then the result of the operation or function is usually null. The following table provides some illustrations and some exceptions:
|
WHEN the expression is … |
THEN the result is … |
|
5 + NULL |
null |
|
LOG(NULL) |
null |
|
NULLIFZERO(NULL) |
null |
|
ZEROIFNULL(NULL) |
0 |
|
COALESCE(NULL, 6) |
6 |