Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

LIKE Escape Sequence

ODBC uses escape sequences for the LIKE clause. The syntax of this escape sequence is as follows:


In BNF notation, the syntax is as follows:

ODBC-like-escape ::=

     ODBC-esc-initiator escape 'escape-character' ODBC-esc-terminator

escape-character ::= character

ODBC-esc-initiator ::= {

ODBC-esc-terminator ::= }

To determine if the driver supports the LIKE escape sequence, an application can call SQLGetInfo with the SQL_LIKE_ESCAPE_CLAUSE information type.

© 2015 Microsoft