15.00 - Nulls and Arithmetic Operators and Functions - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Nulls and Arithmetic Operators and Functions

If an operand of any arithmetic operator or function is null, then the result of the operation or function is usually null. The following table provides some illustrations and some exceptions:

 

WHEN the expression is …

THEN the result is …

5 + NULL

null

LOG(NULL)

null

NULLIFZERO(NULL)

null

ZEROIFNULL(NULL)

0

COALESCE(NULL, 6)

6