Click on 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.