New to Query? Check out Getting Started with Query (PDF) to understand basic concepts and create your first query—all in a matter of minutes!
In Query, there are two types of operators:
- Criteria operators, which tell the query how to compare the field to the record. An example is equals. Note: Not every operator is available for each field.
- Combining operators, which allow you to combine multiple lines of criteria (e.g. filters) in a query.
Note: For the operators when merging queries, refer to What are the merge operators in Query?.
|Equals||Records must have the exact entry you define.||Phone Type equals Home selects only records with Home in the Phone Type field.|
|Does Not Equal||Records must not match the entry you define.||Phone Type Does Not Equal Home selects every record that does not have Home in the Phone Type. (If the record has multiple phone types and one is Home, the record is excluded from the query).|
|Greater Than/Greater Than or Equal To||Records must have a value greater than the one you define.||Gift Amount greater than $100 only selects records with gift amounts of more than $100 (e.g. $100.01 or more). The greater than or equal to operator also includes $100 gifts.|
|Less Than/Less Than or Equal To||Records must have a value less than the one you define.||Gift Amount less than $100 selects only records with a gift amount less than $100 (e.g. $0.00-$99.99). The less than or equal to operator also includes $100 gifts.|
|One Of||Records must have at least one of the entries you define.||State one of NC, SC, FL selects records with an address in one of the three states.|
|Not One Of||Records must not have any of the entries you define.||State not one of NC, SC, FL selects records without any of the three states.|
|Between||Records must fall within the range you define. This criteria operator is inclusive.||Gift Amount between $100 and $300 selects records with gift amounts between $100 and $300. Amounts equal to $100 and $300 are also included.|
|Not Between||Records must not fall within the range you specify. This operator is exclusive.||Gift Amount not between $100 and $300 selects records with gift amounts of less than $100 and more than $300. Amounts equal to $100 and $300 are not included.|
|Blank||Records must have a blank in the field you specify.||First Name is blank selects records with an empty First Name field.|
|Is Not Blank||Records must have an entry in the field you specify.||First Name not blank selects all records with an entry in the First Name field.|
|Contains||Records must contain the defined value anywhere in the field.||Last Name contains L selects records with the letter L anywhere in the last name: Miller, Lawrence, Ball, Clover, etc.||Yes|
|Does Not Contain||Records must not contain the defined value anywhere in the field.||Last Name does not contain L selects records without L anywhere in the last name field. It would exclude Miller, Lawrence, Ball, Clover, etc.||Yes|
|Begins With||Records must have an entry beginning with the value you define.||Last Name begins with Bell selects records whose last name begin with Bell: Bell, Bellmont, Bellingham, etc. It would not include Campbell.||Yes|
|Does Not Begin With||Records selected must not have an entry beginning with the value you define.||Last Name does not begin with Bell selects records whose last name does not begin with Bell. It would exclude Bell, Bellmont, Bellingham, etc. It would include Campbell.||Yes|
|Like||This operator and the wildcard characters are particularly useful when you are not sure of the spelling of a name or if you suspect something might be misspelled||Last Name like B?rd selects records with a similar spelling: Berd, Bird, Burd, or Byrd.||Yes|
|Not Like||Selects the records that are not spelled like the entry you define.||Last Name not like B?rd excludes records with a similar spelling: Berd, Bird, Burd, or Byrd.||Yes|
|Sounds Like||Selects records based on a field for which you do not have the exact spelling.||To add a note about a conversation you had over the phone with a constituent who says their name is Smith. However, their name is actually spelled Smyth, which sounds like Smith. When you query, if you search for "sounds like" Smith, the software will find their record.||Yes|
|Ask||Prompt the user at run-time.||Lets you postpone the selection of specific values for your criteria fields (filters) until the time you actually run the query or use it in another area of the program.||Yes|
|AND||The default combining operator in Query. Records must meet both criteria to be selected.||Last Name equals Smith AND State equals SC|
Selects all constituents whose last name is Smith and whose state is SC. John Smith is only selected if he also has a state of SC.
|OR||Records can meet either criteria to be selected.||Last Name equals Smith OR State equals SC|
Selects all constituents whose last name is Smith and selects all constituents with a state of SC. For example, John Smith is selected because his last name is Smith -- he does not need a state of SC. Mary Jones is selected if she has a state of SC
|Parentheses ( )||Use parentheses to group query criteria when necessary.||For more information, refer to How to use parentheses in query.|