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