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.