Like / Not Like

[purepremiumpulp]

Hi, I tried to search this, but it returned too many results each time I searched, "LIKE"

I am trying to use the SQL command:

name LIKE 'M_ _ _ _'

meaning there are exactly 5 characters, beginning with M...
this didn't work for me in access, any suggestions?

I found that % is replaced with * in access in some cases, thought maybe there were some other quirks I'm missing for this...

 

[Brianwarnock]

Hi

Try Like "M????"
Brian

 

[purepremiumpulp]

too easy
thanks!