Sets the criteria for including or excluding records.
Syntax
public void setFilter( String filter )
Parameters
filter
A string that indicates the criteria for the filter.
Remarks
The criteria string is made up of clauses in the form FieldName-Operator-Value.
You can join clauses with AND and OR.
FieldName is a name of a field in the recordset. You should enclose field names
that contain spaces in square brackets.
Operator is one of the following: <, >, <=,>=, <>, =, LIKE. If Operator
is LIKE, then Value can use wildcards. The asterisk (*) wildcard matches any number
of characters, and the percent sign (%) wildcard matches one character. You can either use
a wildcard at the beginning and end of a pattern, or only at the end.
Value is what you compare to the value of FieldName. Use single quotes
with strings and pound signs (#) with dates. For numbers, you can use decimal points,
dollar signs, and scientific notation.