Re: query in Access with a where block of: Model Like "*470*"
The Asterisk is also used to signify multiplication, so that could be a likely explanation for the trouble you're having.
Without the asterisks it should work.
If the string you're looking for actually contains the asterisk, you can try to convert the characters in the string and search that way.
1) Model LIKE "470" (without asterisks)
2) Model LIKE " & cStr("*470*") & " (whatever the rest of your search string consists of)
|