I'm trying to do a search for a partial string in an Access database using an ADODB recordset in VB 6. However, whenever I do a SQL statement from VB that uses LIKE and an *(to represent any character) no recordset is found.
strSQL = "SELECT * FROM Table WHERE Name Like 'M*'"
when opened with a recordset
rsMember.Open strSQL, etc.
returns nothing, even though, if I were to put this exact SQL statement into a query in MS Access, it would return several records.
If someone could tell me what I am doing wrong and how to correct this problem, I would really appreciate it.