NVL Function Syntax | VantageCloud Lake - NVL Function Syntax - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
[TD_SYSFNLIB.] NVL ( expr1, expr2 )

Syntax Elements

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