Cache numeric comparison via ODBC something is not working
How strange this is to me. I'm querying a table against a numeric(15,2) column call max_client_resp_service. When I query max_client_resp_service > 0 or any number, I get results, but they are not always right, for example where max_client_resp_service > 5 returns values less than 5, e.g. 2.00. When I query < 110 of any higher number I get zero results. It's as though the comparison operator, especially less than function is not working. See attachments for screen shots. I'm stumped. Ok looking at this further, it appears ">" returns all records, "<" returns no results.