NULLIF expressions

Use the NULLIF expressions for conditional expressions in Derby.

NULLIF expression syntax

NULLIF ( L, R )
The NULLIF expression is very similar to the CASE expression. For example:
NULLIF(V1,V2)
is equivalent to the following CASE expression:
CASE WHEN V1=V2 THEN NULL ELSE V1 END