About the operators

The operators fall into the following categories:

Table: Single-value operators lists all the single-value operators that are available.

Table: Single-value operators

Operator	Description
=, NOT =	Use for numbers, dates, and lists. For example: AttachmentsCount=2
<, <=, >, >=	Use for numbers and dates.
CONTAINS, NOT CONTAINS	Use for strings. Wildcards are allowed in the search values. Example 1: subject contains james This search matches all the items that contain the exact word "james" in the subject. Example 2: subject contains james* This search matches both "A quick hello from James" and "A quick hello from Jamestown". You cannot use a wildcard character at the start of a search string.

Operator

Description

=, NOT =

Use for numbers, dates, and lists. For example:

AttachmentsCount=2

<, <=, >, >=

Use for numbers and dates.

CONTAINS, NOT CONTAINS

Use for strings. Wildcards are allowed in the search values.

Example 1:

subject contains james

This search matches all the items that contain the exact word "james" in the subject.

Example 2:

subject contains james*

This search matches both "A quick hello from James" and "A quick hello from Jamestown".

You cannot use a wildcard character at the start of a search string.

Table: Multiple-value operators lists all the multiple-value operators that are available.

Table: Multiple-value operators

Operator	Description
ALLOF, NOT ALLOF	Use for strings. Searches match items that contain (or do not contain) all the values you supply. For example: CC ALLOF bill@example.com ted@example.com This search matches only items that contain both addresses in the CC field. Wildcards are supported.
ANYOF, NOT ANYOF	Use for strings. Searches match items that contain (or do not contain) any of the values you supply. For example: CC ALLOF bill@example.com ted@example.com This search matches items that contain one of the addresses, or both addresses in the CC field. Wildcards are supported.
BETWEEN, NOT BETWEEN	Use for dates. For example: MailDate BETWEEN date1, date2 You must place the earlier date before the later date.
NEAR	Use for strings. Searches match items where the words that you specify are within 50 words of each other. For example: Body NEAR contract money This search matches items where the words "contract" and "money" are fewer than 50 words apart in the body text.

The syntax for searches that contain multiple-value operators is, for example:

attribute operator 'value1
"John Doe"
value3
T:Jane Smith'

Each custodian or target value must be on a separate line.