Problem with LIKE in SQL

[Jose]

I'm trying to use the Like operator in SQL Sentece, but it doesn't work, it doesn't found the data. I'm using the following instructions:

strSearch= "SELECT Code, Name FROM Employees WHERE Name Like 'C*'"

ADOrs.Open strSearch, db, adOpenStatic, adLockOptimistic

I'd tried this same instruction in ACCESS 97 and it works fine.

Why in VB6 doesn't work?

Thanks for your time.