CA OLQ OQ Messages › OQ143051

OQ143051

The ESCAPE character must be followed by %, _, or the ESCAPE character itself in a LIKE pattern string.

Reason:

In the LIKE pattern string, the ESCAPE character must be followed by a %, _, or the ESCAPE character itself. Examples of possible errors are (Note: in these examples the escape character is set to *):

• The ESCAPE character is not followed by %, _, or *:

  SELECT * FROM P WHERE PART-NAME LIKE *nail ESCAPE *
  

• The ESCAPE character is not followed any character:

  SELECT * FROM P WHERE PART-NAME LIKE jack-hammer* ESCAPE *
  

• This statement is correct:

  SELECT * FROM P WHERE PART-NAME LIKE jack*_hammer ESCAPE *
  

Module:

OLQSSCAN

Severity:

0