Comparison operators are available for all data types where comparison makes sense. All comparison operators are binary operators that return values of True, False, or NULL.

Syntax and Semantics

 

<	less than
>	greater than
<=	less than or equal to
>=	greater than or equal to
=	equal
<> or !=	not equal

Notes

The != operator is converted to <> in the parser stage. It is not possible to implement != and <> operators that do different things.

• The comparison operators return NULL (signifying "unknown") when either operand is null.