Hi all,

I have a query where i want to pick all the records with 'denied access' in
them, the records could be as follows;

denied access
denied me access
customer denied access
denied access by customer
customer denied access to me

when i use

like "*denied*" and like *access*" it only returns the last record.....

Do i really have to do:

like "denied*" and like "*access*"
like "denied*" and like "*access"
like "*denied*" and like "*access"

etc etc etc?

There must be an easier way?