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: