Specific and Wildcards in WHERE

  • Thread starter Thread starter AGP
  • Start date Start date
A

AGP

I am letting my user pick a number of 3 letter codes as well as an entry
with a wildcard so he could have:
EEE
ERT
D*T
C**

The first go at this I had a WHERE statement that I built dynamically using
the IN() like so:

WHERE MyCode IN ('EEE', 'ERT', 'D*T', 'C**')
but that doesn't work for the wildcards that I can see. So at this point am
I going to have to split it up into a IN and a OR like so:
WHERE MyCode IN ('EEE', 'ERT') or MyCode LIKE 'D*T' or MyCode LIKE 'C**'

Seems like there should be a more elegant method for this type of query.

AGP
 
Back
Top