Wildcards
Try this --
Like "*denied*access*"
--
Build a little, test a little.
"Emma Hope" wrote:
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?
|