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

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