Searched CASE Expression Syntax | Teradata Vantage - 17.10 - Searched CASE 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)
CASE when_clause [,...] [ ELSE scalar_expression_m ] END

Syntax Elements

when_clause
WHEN search_condition_n THEN scalar_expression_n
scalar_expression_m
A scalar expression whose value is returned when no search_condition_n evaluates to TRUE.
search_condition_n
A predicate condition to be tested for truth.
scalar_expression_n
A scalar expression whose value is returned when search_condition_n is the first search condition that evaluates to TRUE.