query to search records having some chars common

[ajaymansata]

Hi
I would like to fire a query which would give me records having 'm' as first character in the name field
I fired a query
Select * from table where name like "m%";
But it does not seem to work
Now i am not sure if % works in access.From help file i felt it does not.Could someone tell me how can i achieve this.

 

[Alexandre]

Select * from table where name like "m*";

Alex

 

[RV]

It's described in the help file of Access.
Look for the keyword "Like"...

Use * instead of %.

RV