Comparison operators are used to compare one value or expression to another.
All comparison operators return a boolean result.
OperatorExampleUsage
=IF A = B THENThe equality operator.
IF A B THENThe inequality operator.
!=IF A != B THENAnother inequality operator, synonymous with .
~=IF A ~= B THENAnother inequality operator, synonymous with .
IF A The less than operator.
IF A B THENThe greater than operator.
IF A The less than or equal to operator.
=IF A = B THENThe greater than or equal to operator.
LIKEIF A LIKE B THENThe pattern-matching operator.
BETWEENIF A BETWEEN B AND C THENChecks to see if a value lies within a specified range of values.
INIF A IN (B,C,D) THENChecks to see if a value lies within a specified list of values.
IS NULLIF A IS NULL THENChecks to see if a value is null.