Sets the criteria for including or excluding records.
public void setFilter( String filter )
filter
A string that indicates the criteria for the filter.
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.
See Also getFilter, ADO Filter property