Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table (Bad_Words) which contains a list of 100 odd Bad Words; such as
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