Not Like 1

[LonnieJohnson]

How do we say Not Like? Can you use Not with Like

" Select * From MyTable WHERE CUST ID Not Like 'ABC*' "

I want to use this as the sql for a recordset object.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[PHV]

You may try this:
"SELECT * FROM MyTable WHERE [CUST ID] Not Like 'ABC*'"
Or this:
"SELECT * FROM MyTable WHERE Not ([CUST ID] Like 'ABC*')"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[LonnieJohnson]

My apologies, It was actually in the VBA code behind a form. I had an If statement like so...

If MyField NOT LIKE "*abc" Then
'Do something
End If

This doesn't seem to work. What I ended up doing was...

If MyField LIKE "*abc" Then
'Do nothing
Else
'Do something
End If

Unless you have another alternative.

Thanks for the reply.


ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[PHV]

Have you tried this ?
If Not MyField LIKE "*abc" Then

BTW, "*abc" or "abc*" ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[LonnieJohnson]

That's earns you the grand prize! Thanks.

BTW, it didn't matter, I was just using random criteria to indicate any kind of wild card.

Thanks again.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!