NVL Function Syntax | Teradata Vantage - NVL Function Syntax - Analytics Database - Teradata Vantage

[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.