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

Examples

Example 8-41 Comparing Values Using NULLIF

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