16.20 - scalar_expression - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Advanced SQL Engine
Teradata Database
Release Number
Release Date
March 2019
Content Type
Programming Reference
Publication ID
English (United States)

An expression to be evaluated in comparison with a second scalar_expression, including derived periods.

Comparison operators do not support BLOB or CLOB type expressions. You can explicitly cast BLOBs to BYTE or VARBYTE and cast CLOBs to CHARACTER or VARCHAR, and use the result with comparison operators.

An expression that results in a UDT data type can only be compared with another expression that results in the same UDT data type.