HOW TO... search Wildcards in a query?

K

Kevin McCartney

Hi TWIMC

I'm trying to run a query that does not select records where the DEAL_ID
field contains either "*" or "***". I've used Not Like "[*]" which removes
the records where the deal ID has one asterisks but if I try Not Like "[***]"
the other records still remain. So the question is, what criteria do I use to
deselect records that have multiple instances of wildcards?. And no I can't
change the underlining data because that is from a completely different data
system.

TIA
KM
 
T

Tom Ellison

Dear Kevin:

There are literal asterisks and wild card asterisks. The literal one is
inside the square brackets.

To search for anything containing X you would use "*X*"

To search for anything containing an asterisk, use "*[*]*"

Tom Ellison
 
Top