NVL2 Function Syntax | VantageCloud Lake - NVL2 Function Syntax - Teradata VantageCloud Lake

Lake - Working with SQL
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530
[TD_SYSFNLIB.] NVL2 ( expr1, expr2, expr3 )

Syntax Elements

TD_SYSFNLIB.
Name of the database where the function is located.
expr1
A numeric or character expresssion.
  • If expr1 is not NULL, expr2 is returned.
  • If expr1 is NULL, expr3 is returned.
expr2
A numeric or character expresssion.
expr3
A numeric or character expresssion.