Comparison Operators
Operator  Purpose  Precedence 


Checks that the expression on the left is (not) 
1 

Is equal to, is identical to 
2 

Is not equal to 
2 

Is greater than 
2 

Is less than 
2 

Is greater than or equal to 
2 

Is less than or equal to 
2 

Is not greater than 
2 

Is not less than 
2 
This group also includes comparison predicates BETWEEN
, LIKE
, CONTAINING
, SIMILAR TO
and others.
IF (SALARY > 1400) THEN
...