15.00 - 3997 The ESCAPE value for LIKE must be One Character. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Language
English (United States)
Last Update
2018-09-24

3997 The ESCAPE value for LIKE must be One Character.

Explanation:

The user has specified a character string value for the ESCAPE character in a LIKE comparison which has a length other than one.

Generated By:

OptCType module.

For Whom:

End User

Remedy:

Change the query to use a character string of length one.