If an operand of an arithmetic operator or function is null, the result of the operation or function is null, with the following exceptions:
| Expression | Result |
|---|---|
| 5 + NULL | null |
| LOG(NULL) | null |
| NULLIFZERO(NULL) | null |
| ZEROIFNULL(NULL) | 0 |
| COALESCE(NULL, 6) | 6 |
If an operand of an arithmetic operator or function is null, the result of the operation or function is null, with the following exceptions:
| Expression | Result |
|---|---|
| 5 + NULL | null |
| LOG(NULL) | null |
| NULLIFZERO(NULL) | null |
| ZEROIFNULL(NULL) | 0 |
| COALESCE(NULL, 6) | 6 |