Using multiple Like(s) * in a query

  • Thread starter Thread starter paulquinlan100
  • Start date Start date
P

paulquinlan100

Hi

Just a quick one, is there a way of selecting using Like* multiple
times in a query in a similar way to using IN e.g. IN("a","b","c")
rather than having to use multiple OR statements?

Thanks for any suggestions
Paul
 
Paul,

Using your example:
Like "[a-c]*"
.... or:
Like "[a,b,c]*"
 
You must log in or register to reply here.

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

Similar Threads

Best Gmail Backup Tool to use in 2025? 3
Replacement for multiple spreadsheets 3
using dlookup in a query 2
Firefox Multi-Account Containers 1
Automated Solution to Repair PST Files 2
Query Question 4
Voltage supply issue related to NUC PC Core i7 0
Is there no "AND" function in Access like in Excel? 2

Back
Top