Comparison and Relational Operators
Comparison operators are used to compare operands in basic and quantified predicates. Relational operators are used to compare operands in all other predicates. see Predicates.
Both comparison and relational operators perform essentially similar functions. The comparison operators are however common to most programming languages, while the relational operators are more or less specific to SQL.
= equal to <> not equal to < less than <= less than or equal to > greater than >= greater than or equal to
BETWEEN EXISTS IN IS LIKE OVERLAPS
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40