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

SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
SQL_Functions__Expressions__and_Predicates.Upload_071421/djk1612415574830.ditamap
dita:ditavalPath
SQL_Functions__Expressions__and_Predicates.Upload_071421/wrg1590696035526.ditaval
dita:id
B035-1145
lifecycle
previous
Product Category
Teradata Vantageā„¢
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