Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

LIKE Escape Sequence

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

{'escape-character'}

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.