This is a fairly common filtering issue that even basic programs can perform. I am not sure why CC doesn't include both. iContact does this perfeclty. Basically, you want to search a field or tag that includes a specific text you choose. For example, if I have a marketing piece for anyone with "Jack" in their name, I want to bring results such as Jack, Jackson, Jackle, Jackh, Jackobson, so on and so forth. Now for multiple filters ro fields, there needs to be an "OR" field. Using a similar example as above, I wan to filter for all first names that have "Jack" OR "John" (ex Jack Wellings, Jack Adams, John Adams, John Hancock), but CC does an AND filter by default. Basically if I add this sort of filter, CC wants to find all contacts that have both "Jack" AND "John" as the first name, which needless to say is highly unlikely.
... View more