Hi,
I have a table (Bad_Words) which contains a list of 100 odd Bad Words; such as
NO MAIL |
NONAME |
NOT GIVEN |
NOT PROVIDED |
NOT SUPPLIED |
RETURNED |
etc
etc
Now, I know how to identify if the full field matches one of these words.
What I am trying to work out is an easy way to identify if a field contains any of the words in this table
Ie. 'MAIL RETURNED' in a field would be caught as 'RETURNED' is in the Bad_Words table
Any thoughts?
Thanks
Stuart