field contains " "

  • Thread starter Thread starter Katia
  • Start date Start date
K

Katia

I would like to search within a category using the
command; field contains "x". How do I do this?
 
Dear Katia:

For the Jet database engine, use:

LIKE "*x*"

For MSDE use:

LIKE '%x%'

This is case INsensitive.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top