Question with ADO Find method...
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%')"
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.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center