The following table lists the available null handling functions, and a description of their purpose.
Function | Description |
---|---|
NVL | Replaces a NULL with a numeric or a string value as the result value. |
NVL2 | Returns one of two values based on whether or not expr1 is NULL. |
See the Teradata Database SQL Functions, Operators, Expressions, and Predicates document, B035-1145, for a detailed overview of these null handling functions.