Like operator and wildcards in ADO VB6
Could you be using the wrong Access wildcard character?
The wildcard character for Access is the asterisk "*".
The wildcard character for other databases is the percent sign "%".
Robert R. Thele
[Remove NoSpam_ to reply via E-mail]
>When selecting a recordset either with the ADO control or through the query
>wizard (Accessing a Jet database) using the like operator and wildcards,
>returns no records. Using an exact string works fine. Any ideas why this is.