LIKE won't work in VBA/ADO app
 

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

LIKE won't work in VBA/ADO app
 

Try LIKE 'Gu%'

RBS


"Gustaf" wrote in message
...
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

LIKE won't work in VBA/ADO app
 

RB Smissaert wrote:
Try LIKE 'Gu%'

It worked! Thank you!

Gustaf