I have a SQL Server table with an ID field that is of type integer.

Using pure SQL I can get execute a query that returns ALL records that have
an ID that start with 2. For example:

select * from tbl where Convert(char(6),ID) like '2%'

I am ALSO trying to use the FIND method on an ADO Recordset to do the same
thing. I am using the following code:

strFind="(Convert(char(6),AssociationID) like '2%')"
objRS.Find strFind

When I try this I am getting an error of indicating WRONG TYPE.

Is there something that is different about using the FIND method on the ADO

Any ideas/suggestions would be greatly appreciated.