Contents Index Invalid escape character '%1' Invalid expression in WHERE clause of Transact-SQL outer join

ASA Error Messages
  Database Error Messages
    Alphabetic list of error messages

Invalid escape sequence '%1'


Item Value
SQLCODE -630
Constant SQLE_INVALID_ESCAPE_SEQ
SQLSTATE 22025
Sybase error code 7705
ODBC 2 State S1000
ODBC 3 State 22025
Parameter 1 The escaped character
Probable cause 

A LIKE pattern contains an invalid use of the escape character. The escape character may only precede the special characters '%', '_', '[', and the escape character itself.


Contents Index Invalid escape character '%1' Invalid expression in WHERE clause of Transact-SQL outer join