Suppose I have the following list of Contacts in my Personal Contacts folder that represent the customers and prospects I’m currently dealing with. (For details on how to import this set of data, if you’d like to try the exercises described, please refer to Importing the Sample Data)

I want to get a listing of just those contacts that are marketing decision makers based on the West Coast (of the United States) say for the purposes of sending them a newsletter or direct mailing.

In order to do this, I need to create a filtered view in Outlook. (A view is a sub-set of my data in a particular folder that is grouped, sorted, and filtered according to specified criteria). However, in certain cases (such as the task for this exercise), the criteria for the filter conditions are such that they cannot be set up using the basic filter dialogs, and require they be entered via the SQL Tab.

My first challenge is in Identifying the Filter Conditions that equate to these specific criteria.