Not Like "*/CTO/*" not working

Hi,

I need a little help with the following access query.

I have a large table with many fields, three in particular that may contain the verbiage, /CTO/. I want to see all records except those that contain this verbiage.

My query is using, Not Like "*/CTO/*" in a separate Criteria row for each of these fields.

The results still returns records with the /CTO/. Not sure why?

Any help is appreciated.



Thanks,

NLR

Not Like "*/CTO/*" not working