The IN operator is a useful way to query for records with parameters that match the values in a collection. However, searching for records with parameters that are not in a collection set is just as useful too. The code below gives an example of how this can be done. The example below queries for customers that do not belong to the states in the collection (California, New York, and Washington).

It does this by looping through the collection, analyzing each element, and querying for records that do not match.