COALESCE Expression | Teradata Vantage - COALESCE Expression - Analytics Database - Teradata Vantage

SQL Functions, Expressions, and Predicates

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-01-12
dita:mapPath
obm1628111499646.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
kby1472250656485
lifecycle
latest
Product Category
Teradata Vantageā„¢

Returns NULL if all its arguments evaluate to null. Otherwise, it returns the value of the first non-null argument in the scalar_expression list.

COALESCE is a shorthand expression for the following full CASE expression:

   CASE 
    WHEN  scalar_expression_1  IS NOT NULL 
    THEN  scalar_expression_1  
    ...
    WHEN  scalar_expression_n  IS NOT NULL 
    THEN  scalar_expression_n  
    ELSE NULL 
   END

Default Title

The default title for a COALESCE expression appears as:

<CASE expression>