I'm using VB6 and Access 97
I want to use wildcards to aid in my find
i.e *the*, etc.

The problem being is I cannot get it to work with a numerical field, so I cannot find on
*1*, 22*, etc. A straight forward find work okay find = 1. I can do any type of find with a text field though. I know you don't use the * for wildcards.

------------------