You might obtain unexpected results if a literal number that you specify as an operand is not in a format that can exactly represent the data type of another value with which it is compared by a relational operator. Because of rounding errors, for example, a relational operator like = or the equals( ) operator function generally cannot return TRUE if one operand returns a FLOAT value and the other an INTEGER. For information about which of the built-in data types store values that can be exactly represented as literal numbers, see the section Literal Number.
For a discussion of relational operators in the SELECT statement, see the IBM Informix Guide to SQL: Tutorial.
For a discussion of the GLS aspects of relational operators, see the IBM Informix GLS User's Guide.