Previous Topic: -41 - DATATYPES OF OPERATION op-string NOT COMPATIBLENext Topic: -43 - COLUMN FUNCTION ON INVALID TYPE


-42 - INVALID USE OF ESCAPE CHARACTER IN PATTERN OF LIKE PREDICATE

Reason:

When an escape character is used in the pattern of the LIKE predicate, it must be followed by the percent character (%), the underscore character (_), or another escape character. The word character in this context refers to either a Single-Byte Character Set (SBCS) or Double-Byte Character Set (DBCS) character. Any other use of the escape character in the pattern of the LIKE predicate is invalid.

The SQLSTATE that equates to this SQL return code is 2200C.

Action:

Determine what caused this error with regard to the above and correct it.