Help with "Like" operator-- VB 6 with Access database 1

[PeterS]

I'm trying to use the "Like" operator. "Like" works as expected in an Access query, but when I try to use it in VB code it returns only an exact match. For example,

 Like 'John Doe'

would return records with John Doe, but

 Like 'John D'

returns nothing, as do

 Like 'John D*'

and

 Like 'John Do?'

.

 Like 'J*'

also returns nothing. Needless to say, there are no records that are exactly 'J*', 'John D', 'John D*' or 'John Do?'.
Any work-arounds or explanations of what I'm doing wrong would be appreciated!

 

[PeteG]

Try % instead of *, eg "Like 'John D%'"

 

[jjames]

I've just looked at some working code which uses the Like operator and your syntax looks the same. Must be something else about your SQL statement or VB syntax. Can you give more detail?

 

[PeterS]

The "%" solved the problem! Thanks!