NULLIF Expression Syntax | Teradata Vantage - NULLIF Expression Syntax - Advanced SQL Engine - Teradata Database

NULLIF ( scalar_expression_1, scalar_expression_2 )

Syntax Elements

scalar_expression_1

The scalar expression to the left of the = in the expanded CASE expression:

CASE 
  WHEN scalar_expression_1 = scalar_expression_2 
  THEN NULL
  ELSE scalar_expression_1 
END

scalar_expression_2

The scalar expression to the right of the = in the expanded CASE expression:

CASE 
  WHEN scalar_expression_1 = scalar_expression_2 
  THEN NULL
  ELSE scalar_expression_1 
END