LIKE won't work in VBA/ADO app

[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

 

[RB Smissaert]

Try LIKE 'Gu%'

RBS

 

[Gustaf]

Try LIKE 'Gu%'

It worked! Thank you!

Gustaf