Escape Connection Parameter [ESCAPE]

Allows you to specify the escape character used in the LIKE clause of SQL statements generated by the ODBC driver when returning a list of tables or column.

Description

The Escape parameter is supported only by SAP Sybase IQ.

By default, the ODBC driver uses the tilde (~) as an escape character, but some applications assume that the escape character is a backslash (\). For example, the default escape character for characters stored as hexadecimal codes and symbols is a backslash (\), so \x0A represents the line feed character.

Examples

To use the exclamation mark as the escape character, enter:

ESCAPE='!'