How to Find All Contacts in Several States

Hope everyone is having a great summer!

Here’s a handy SQL query that might be a introduction to the ‘in’ statement for many of you.  This example will quickly find all the contacts in several different states without stringing together multiple ‘or’ statements.

select company, contact, source, key1, STATE, createon from contact1
where state in ('MA', 'NH', 'VT', 'CT', 'ME', 'RI')
order by state, company

To use this, from GoldMine’s main menu choose Lookup | SQL Queries then copy & paste the above in the top section then click Query.  If you are using GoldMine Premium Edition then Tools | Filters & Groups and then the SQL Query tab.

Changing which states will be list is as easy as changing what’s between the “(” and “)”.