HOW TO... search Wildcards in a query?

[Guest]

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

 

[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

 

[Van T. Dinh]

To select something that does NOT contain "*", use:

Not Like "*[*]*"