The following operators can be used in filters:
= |
Equal |
<> or != |
Not Equal |
< |
Less Than |
> |
Greater Than |
<= |
Less Than or Equal To |
>= |
Greater Than or Equal To |
Generally, with text columns, it is best to use = or !=.
Make sure that any text that appears in the statement is surrounded by single quotes (').
To combine multiple conditions, use the AND or OR operators, for example %1>2000 AND %2<1000.
See also: