NULLIF

Compares the two arguments and yields null when they are equal; otherwise preserves the first argument.

Category: Utility Functions

Syntax

NULLIF(value, compare)

Arguments

• value any Primary input value.
• compare any Value to compare against the primary input.

Returns

same as value — Returns a value with the same type as value.