The Teradata LIKE clause does not contain an escape character in the same sense as ODBC; therefore, pattern escape characters for one string must either be in use or not be in use. The following table provides an example of the ODBC Pattern Escape Character:
|Valid Syntax||Illegal Syntax|
If a string containing an escaped pattern character also contains an un-escaped pattern character, the string will be converted to all un-escaped characters. For example:
The string “table\_emp%” will be converted to “table_emp%”.