Supported Comparison Operators

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

Teradata Database supports the following comparison operators.

ANSI Operator Teradata Extensions Function
= EQ Tests for equality.
<> ^=
NE
NOT= Tests for inequality.
< LT Tests for less than.
<= LE Tests for less than or equal.
> GT Tests for greater than.
>= GE Tests for greater than or equal.