SQL Problem with LIKE statement

[daimaou]

Hi. I'm having problems using the LIKE statement on VB...
I need to store on a recordset every records having the ID field begining with a '7'. I'm using ADO connecton to MS Access. OK so I suppose it would be something like this for the Select string:

str = "SELECT * FROM Table1 WHERE ID LIKE '7*'"

I guess this should work right?
But it'll return an empty recordset... I've tryed to make this query on Access and it worked. Am I doing something wrong? Since this should be pretty easy...

Any help is appreciated.

 

[daimaou]

oops! My mistake... I should use the '%' wildcard instead of the '*', it's the habit
Now it's working.