Finding with ADO

[parkes]

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.

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

[TeR]

Try using single quotes around the search phrase. If you're looking for the number one, it would look like this. '1'

Feel free to email me if I need to explain further.

------------------
~John