SQL$HELP72.HLB  —  Errors  SQL_ERRORS, NUMCMPTXT
  Numeric column will be compared with string literal as text

  Explanation:  You tried to compare a text literal with a numeric
  column.  The numeric column is converted to text and the
  comparison is made from left-to-right, character by character.
  This can lead to unexpected results.  For example, the
  comparison N between "0001" and "0999", no matter what N is,
  will never be true, because N is converted to text without a
  leading zero and compared alphabetically with the two string
  literals.

  User Action:  None, as long as you understand the semantics of
  the operation.  You should be aware that the comparison will
  take place between text values.
Close Help