Jet SQL syntax question

How do I do wildcards (for numbers or strings) in Jet SQL. My book says

WHERE [field] Like '*'

and

WHERE [field] Like #

but these didn't work. What's the correct syntax? Thank you.

[Kyle Luman]

I am wondering this same question. The SQL works fine in Access with the wild cards but not through ADO to the Jet engine.

I can get SQL to work if I am not using wildcard characters, but that greatly limits the flexibility of the program.

[kornilow]

WHERE [field] Like '%A%';

If i help - rate.

Try "where field like '%'"

[Hellbound]

You will just have to supply double quotes, i.e.:
WHERE [field] Like "*"