What's wrong with this query?

I have the following ADO line in my program:
adoRS.Open "Select Ssn From Participants Where [Full Name] Like '" & strParticipant & ",*';", adoConn


The query returns no record (adoRS.EOF = True), even though the name appears in the database. In other words, if strParticipant is 'Smith', the query does not find 'Smith, John'. Any ideas?

Thanks in advance,

Jamie Nordmeyer
Portland, OR, USA

Forgot to mention; the database is an Access 2.0 database (Yech, I know, but it's what I have to work with), and I'm using ADO 2.5.

Any queries on an access db using 'like' uses the wildcard character '%' and not the '*'.


David Paulson

Hmph! Figures. What's up with that? Who ever decided to use '%' instead of '*' (which is the standard, correct?) should be fired. Oh well. Thanks for the tip. It works now.