SQL Codes › SQL Return Codes -1 through -999 › -299 - LIKE ESCAPE OPTION NOT ALLOWED WITH MIXED DATA

-299 - LIKE ESCAPE OPTION NOT ALLOWED WITH MIXED DATA

Explanation

The LIKE predicate contains an escape clause and is testing an expression containing mixed data. The LIKE predicate does not allow an escape clause to be used with mixed data.

The SQLSTATE that equates to this SQL return code is 0AS06.

User Response

Modify the expression to remove the mixed data or remove the escape clause.