Restrictions on the Data Types in a NULLIF Expression

Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

The following restrictions apply to CLOB, BLOB, and UDT types in a NULLIF expression.

Data Type Restrictions
BLOB A BLOB can only appear in the argument list when it is cast to BYTE or VARBYTE.
CLOB A CLOB can only appear in the argument list when it is cast to CHAR or VARCHAR.
UDT Multiple UDTs can appear in the argument list only when they are identical types and have an ordering definition.