TABLE OF CONTENTS Dr. codd introduced the term "theta operators" in his early papers to refer to what a programmer would have called comparison predicate operators. The large number of data types in SQL makes doing comparisons a little harder than in other programming languages. Values of one data type have to be promoted to values of the other data type before the comparison can be done. The available data types are implementation-and hardware-dependent, so read the manuals for your product.
The comparison operators are overloaded and will work for
operator numeric character datetime========================================================================== < : less than (collates before) (earlier than) = : equal (collates equal to) (same time as) > : greater than (collates after) (later than)<= : ...
