NULLIF

The NULLIF function compares one expression with another and returns NA when the expressions are equal, or the base expression when they are not.

Return Value

NA when the expressions are equal, or the base expression when they are not.

Syntax

NULLIF (expr1 , expr2)

Parameters

expr1

An expression. The base expression for the comparison

expr2

An expression to compare to expr1.

Examples

SHOW NULLIF(1, '1')
NA
 
SHOW NULLIF('red', 'Red')
red