Comparison Operators | VantageCloud Lake - Comparison Operators - Teradata VantageCloud Lake

Comparison operators, which are types of logical predicates (also called conditional expressions), test the truth of relations between expressions.

• IF, WHILE, REPEAT, and CASE statements in stored procedures
• WHEN clauses in searched CASE expressions
• WHERE, ON, and HAVING clauses to qualify or disqualify rows in a SELECT statement
• CASE_N functions

See the following sections:

• Comparison Operator Syntax
• CASE Results
• Comparison Operators Usage Notes
• Example: Using the ALL Quantifier to Compare Two Expressions

The following comparison operators are ANSI SQL:2011 compliant:

• =
• >
• <
• <>
• <=
• >=

The following comparison operators are Teradata extensions to the ANSI SQL:2011 standard.Their use is deprecated:

• EQ
• ^=
• NE
• NOT=
• LT
• LE
• GT
• GE