We have migrated our database from Sybase to Oracle and are finding that when we open recordsets that the fields of the recordsets are not assuming the underlying datatype. For example when we do a compare on like rs("ID") > 10, we are finding that we get a get a type mismatch, even though rs("ID") is defined as numeric on the DB, and contains numeric data. Our work around is to wrap rs("ID") with cInt(), but that is getting old quick. Everything worked fine with the Sybase DB, so we feel it has to be something with the connection. Any ideas would be appreciated.