query help

[Hahas]

I want to add a query on a form called Customers...

So, I want to type the begining of the Customer's name, and when i push the button, on the datagridview appear all the Customers with a name like that....

How to use the 'like' on a select.... PLEASE help me.....

My database is Access....

[quincarroll]

Try...

SELECT * FROM Customers where name like '*nes' - Returns where name ends in "nes"

or

SELECT * FROM Customers where name like 'jo*' - Returns where name starts with "jo"

or

SELECT * FROM Customers where name like '*one*' - Returns where name contains "one"

The "*" is the wild card character in Access

[Hahas]

I found the solution to my problem. Your reply was helpful. Thank you