NULLIF is a miscellaneous function that returns a NULL value if the arguments are equal.
CASE WHEN e1=e2 THEN NULL ELSE e1 END
When e1=e2 evaluates to unknown (because one or both of the arguments is NULL), NULLIF returns the value of the first argument.
Related concepts
ESQL
Related tasks
Developing ESQL
Related reference
Syntax preference
Miscellaneous ESQL functions
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ak05880_ |