Crystal Reports - How to Use the IN Statement

Question:
I have a Crystal Report created for an email blast (includes Organizations and Individual accounts) and I need to include a statement that says not to include the account in the list if any of their affiliation codes (EV899_AFFIL_MASTER.EV899_AFFIL_CODE) include “X”, “Y” OR "Z".  What statement should I use to accomplish this?

Answer:
The use of the "IN" statement could be very useful on these type of scenarios. This will allow you to filter your data based on a set of values, for example:
        {EV899_AFFIL_MASTER.EV899_AFFIL_CODE} IN ["X", "Y", "Z"];

If we need to list "everything but" a specific list of items, a statement like this can be used:
        NOT({EV899_AFFIL_MASTER.EV899_AFFIL_CODE} IN ["X", "Y", "Z"]);