ADO Find using wildcard on an integer

dfbosse · June 25th, 2003, 10:34 AM

I have an ado recordset which contain order id's (the field is defined in the database as an integer). In my application, I want to find, for example, the first order id that begins with a 2. When I try to execute the following statement :

rs.find "ID LIKE '2%'"

I get the error:

Find cannot be performed over the specified column, or compare operator is invalid.

I experimented, and it appears that the wildcard does not work on an integer field.

Does anyone know a way around this?

Thanks!!

Jeff Mason · June 25th, 2003, 10:44 AM

The LIKE operator only works on character string data. You could define another column in your recordset which CASTs the ID column to a varchar, then use that column in your search expression. E.g:

Code:

SELECT ID, CAST(ID as varchar(10)) as StringID, ...

then use:

rs.find "StringID LIKE '2%'"

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

mark.roworth · June 26th, 2003, 02:14 AM

That is because you are using a string function with an integer. What may work is something like:

rs.Find "CStr(ID) LIKE '2%'"

Mark Roworth