Error Messages (U) A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #Use integer function to compare index-field and decimal The "use integer function to compare index-field and decimal" error message occurs when queries compare fields with differing datatypes. If you experience "integer function" errors, use the INTEGER( ) function to convert non-integer datatypes to integer. For example:SELECT * FROM TABLE WHERE INTFIELD >= 3.5 (wrong) SELECT * FROM TABLE WHERE INTFIELD >= INTEGER(3.5) (correct) Be advised. If you proceed, all decimal values will be rounded off and precision will be lost. Evidence ODBC Client Trace Table Schema