When you define a query, you establish a set of conditions each record must meet to be included in it. To establish these requirements, apply the criteria operators to the fields you select to use as filter fields for the query.
 
Criteria OperatorDescriptionExample Results
Equal toThe records selected must have the exact value defined.First Name Equal to David:
Only records with the exact entry of David as the first name are selected.
IsAvailable for date fields.
The records selected must have the exact value defined.
Date Added Is 01/01/2014:
Only records with the exact entry of 01/01/2014 as the date added are selected.
Not Equal to^*The records selected must not have the exact value defined.Constituency Not Equal to Board Member:
Only records that do not have the constituency of Board Member are selected.
Is Not^*Available for date fields.
The records selected must not have the exact value defined.
Revenue/Date Is Not 01/01/2014:
Only records that do not have a Revenue/Date of 01/01/2014 are selected.
One ofThe records selected must have one of the values defined.City One of Orlando, Tampa, Lakeland:
Only records that have a city of Orlando, Tampa or Lakeland are selected.
Not One of^*The records selected must not have any of the values defined.City Not One of Orlando, Tampa, Lakeland:
Only records that do not have a city of Orlando, Tampa or Lakeland are selected.
Less Than*The records selected must have an entry less than the value defined.Amount Less Than $500
Only records that have an amount less than $500 are selected.
Before*Available for date fields.
The records selected must have a date before the value defined.
Date Added Before 01/01/2014
Only records that have a date added prior to 01/01/2014 are selected.
Less Than Or Equal To*The records selected must have an entry less than or equal to the value defined. Amount Less Than Or Equal to $500
Only records that have an amount less than or equal to $500 are selected.
On or Before*Available for date fields.
The records selected must have a date on or before the value defined. 
Date Added On or Before 01/01/2014
Only records that have a date added on or prior to 01/01/2014 are selected.
Greater ThanThe records selected must have an entry greater than the value defined.Amount Greater Than $500
Only records that have an amount greater than $500 are selected.
AfterAvailable for date fields.
The records selected must have a date after the value defined.
Date Added After 01/01/2014
Only records that have a date added after to 01/01/2014 are selected.
Greater Than Or Equal ToThe records selected must have an entry greater than or equal to the value defined. Amount Less Than Or Equal to $500
Only records that have an amount greater than or equal to $500 are selected.
On or AfterAvailable for date fields.
The records selected must have a date on or after the value defined. 
Date Added On or After 01/01/2014
Only records that have a date added on or after 01/01/2014 are selected.
BetweenThe records selected must fall within the value range defined. This condition is inclusive.Date Between 1/1/14 and 1/31/14
Only records that have a date between 1/1/14 and 1/31/14 will be included as well as the dates 1/1/14 and 1/31/14.
Not Between*The records selected must not fall within the value range defined. This operator is exclusive.Date Not Between 1/1/14 and 1/31/14
Only records that have a date before 1/1/14 and after 1/31/14 will be included. Records with dates of 1/1/14 and 1/31/14 will not be included.
LikeThe records selected must be spelled like the value defined. Last/Organization/Group/Household Name Like Smith
Only records spelled like Smith will be included.
Not Like*The records selected must not be spelled like the value defined.Last/Organization/Group/Household Name Not Like Smith
Only records not spelled the Smith will be included: Hernandez, Corizon, Lewis etc.
Begins WithThe records selected must have an entry that begins with the value defined. Last/Organization/Group/Household Name Begins With Smith
Only records that begin with Smith will be included: Smith, Smithwick, Smithton.
Does Not Begin WithThe records selected must not have an entry that begins with the value defined. Last/Organization/Group/Household Name Does Not Begin With S
Only records that begin with any letter except S are included.
BlankThe records selected must have no entry in the selected field.Email Address is Blank
Only records that do not have an email address will be included.
Not BlankThe records selected must have an entry in the selected field. Email Address is Not Blank
Only records that have an email address will be included.
ContainsThe records selected must contain the value defined anywhere in the selected field. Last/Organization/Group/Household Name Contains Sm
Only records that contain sm are included: Smithson, Smuf, Chasm
Does Not Contain*The records selected must not have the value defined anywhere in the selected field.Last/Organization/Group/Household Name Does Not Contain Sm
Only records that do not contain sm are included: Johnson, Hernandez, Thomas etc.
Sounds LikeThe records selected must sound like the value defined. Last/Organization/Group/Household Name Sounds Like Smith
Only records that sound like smith are included: Smith, Smythe, Smoot, Smithe
 ^ For some fields, the Only return records that do not have a value equal to the selected value checkbox appears. To not return records associated with the value selected for the field, regardless of whether the record is associated with additional values for the field, select this checkbox. For example, if Robert Hernandez has multiple constituencies of Board Member, Volunteer, and Alumnus, and you select Constituency is Not Equal To Board Member, the results will not include Robert’s Alumnus constituency record or any other constituency records for Robert.
If you do not select the checkbox, the results do not include records associated with Alumnus, but does include records for Robert's additional constituencies.

*The Include blanks checkbox appears for the criteria operators of Not Equal To, Is Not, Not One Of, Less Than, Before, Less Than or Equal To, On or Before, Not Between, Not Like, and Does Not Contain. To include records with no entry for the selected field, select this checkbox. If the checkbox is not selected, records with no entry for the field do not appear in the results. From Administration, you can use the Enable/Disable Default Blank Query Criteria configuration task select whether to select Include blanks by default.