criteria in query part of field text only

M

MemphiDoug

In my email field, I want to query only the aol.com users. I have
tried ="*[aol.com]*", I have tried LIKE "*[aol.com]*", I have tried
just "aol.com" I can't figure out how to have it give me only the
people that have "aol.com" as part of their field entry in my email
field. Help?

Doug
 
P

pdm

The only one you didn't try was the one you wanted. Murphy's law.
Like "*AOL.COM*
Brakets "[" and "]" have special meaning with LIKE.
 
Top