Sandy, I don't think Marketo views the problem this way. Our client actually had a chat with support about it, and got this answer: "After some additional research and investigation, I was able to determine that the 'contains' operator will allow any lead through that has any complete character value for each word in the list...Unfortunately, there is not a set way to avoid this, because the 'contains' operator is designed to cast the widest net possible when searching for values. As long as a lead's value contains all of any single word(or character string), they will qualify for the list. This is especially true when using 1000+ different words/character strings...if filter 'contains: wal mart', it will return leads like walgreens, smart list, kmart, etc., because it only needs to identify the individual words."
... View more