using "like" in SQL Statement

I have a table ("part") in Access 97 database which have two field "id" and "info".

I use ADO connect to the database by following code:

Code:

---

dim Db as New Adodb.Connection

Db.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & db_path & "\part.mdb"
Db.Open

---

then I use the following query;

Code:

---

dim rs as adodb.recordset
set rs = db.execte("select * from part where info like 'M*'")

---

However, the recordset don't have data but the table have two record which value = "Mother", "Man". So it should return two recrod!?

I don't know what problem it is, but I have test the query in access and it is work!

So please tell me why if anyone have solution, Thank!

Have you tried "like 'ma%'? I know the larger DB's (SQL Server & Informix) prefer using the percent sign rather than an asterisk.

Woo. It work, Thank!