NULLIFZERO
Purpose
This function returns the value NULL if number has value 0. Otherwise, a number is returned.
Syntax
nullifzero::=
Usage Notes
- The NULLIFZERO function is equivalent to the CASE expression CASE WHEN number=0 THEN NULL ELSE number END.
- Additionally, refer to ZEROIFNULL.