Comparison Operators | Teradata Vantage - 17.10 - Comparison Operators - Advanced SQL Engine - Teradata Database

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

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

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