Using Wildcard Characters as Literal Characters

To search for the occurrence of %, _, [, ], or ^ within a string, you must use an escape character. When a wildcard character is used in conjunction with an escape character, the SAP ASE server interprets the wildcard character literally, rather than using it to represent other characters.

• Using Square Brackets ( [ ] ) as Escape Characters
  Use square brackets as escape characters for the percent sign, the underscore, and the left bracket. The right bracket does not need an escape character; use it by itself. If you use the hyphen as a literal character, it must be the first character inside a set of square brackets.
• Using the escape Clause
  Use the escape clause to specify an escape character. Any single character in the server’s default character set can be used as an escape character. If you try to use more than one character as an escape character, the SAP ASE server generates an exception.