Filtering Items Using Comparison and Logical Operators
You can use the following comparison operators in filter strings using Microsoft Jet syntax or DAV Searching and Locating (DASL) syntax:
Performs a less-than comparison.
Performs a greater-than comparison.
Performs a less-than-or-equal-to comparison.
Performs a greater-than-or-equal-to comparison.
Performs a not-equal-to comparison.
Performs a equal-to comparison.
You can use the logical operators And, Not, Or in filter strings in Jet or DASL syntax. The order of precedence of these operators, from the highest to the lowest, is: Not, And, Or. You can use parentheses to indicate specific precedence in a filter. Logical operators are case-insensitive.
Performs a logical NOT on the condition. The following code retrieves all contacts whose first name is Jane and who do not work at Microsoft.
criteria = _ "[FirstName] = 'Jane' And Not([CompanyName] = 'Microsoft')"
Performs a logical AND on the condition. The following code retrieves all contacts who work at Microsoft and whose first name is Mary.
criteria = _ "[FirstName] = 'Mary' And [CompanyName] = 'Microsoft'"
Performs a logical OR on the condition. The following code returns all contact items that have either a first name of Peter or Paul.
criteria = "[FirstName] = 'Peter' Or [FirstName] = 'Paul'"