Tips for creating queries
To find multiple word items, enclose the words in quotation marks. For example, to find New York, type "New York".
If you enter search criteria in more than one field the && (and) operator is automatically used between these fields. For example, if you enter London in the City field and prospect in the ID/Status field, the query finds all prospects in London. If you want the relationship between fields to be OR (||), you must create an Advanced query. See Creating an advanced query.
To find all contacts that have any data in a specific field, type an asterisk in the field.
Queries are not case-sensitive; you do not have to enter text with the correct capitalization. You could enter "XYZ COMPANY" or "xyz company" to find all contacts at XYZ Company.