Click the name of an operator to learn more: 

=, <, >	equal, less than, greater than
<>	not equal
<=	less than or equal
>=	greater than or equal
#IN	Returns 1 if a database field value occurs in a list, otherwise 0.
#NOTIN	Returns 1 if a database field value does not occur in a list, otherwise 0.

All of these operators may be used with database fields of the numeric, date and coded type. To compare values of a character database field, however, you must use the #IN and #NOTIN operators.