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

Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1145-171K
Language
English (United States)
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