LIKE won't work in VBA/ADO app

  • Thread starter Thread starter Gustaf
  • Start date Start date
G

Gustaf

I'm calling an Access DB from Excel, and on some queries, I want to use LIKE. But I always get an empty recordset, even if there are matching records! The query looks like this:

SELECT * FROM Person WHERE [Name] LIKE 'Gu*' ORDER BY [Name]

Is there anything wrong with this query? If I write out the full name (LIKE 'Gustaf') I get a matching record.

Gustaf
 
Back
Top