Comparison operators determine the relationship between different parts of a search condition, e.g. to search for all students from SHEFFIELD, the condition used may be


HTOWN="SHEFFIELD"

 

The common comparison operators are shown below:

 

=       equal to

 

<>   not equal to

 

<     less than

 

>     greater than

 

<= less than or equal to

 

>=  greater than or equal to