The NULLIF function can be used for conditional expressions in Derby.

NULLIF ( L, R )

The NULLIF function is very similar to the CASE expression. It returns NULL if the two arguments are equal, and it returns the first argument if they are not equal. For example,

NULLIF(V1,V2)

is equivalent to the following CASE expression:

CASE WHEN V1=V2 THEN NULL ELSE V1 END