DB2 LIKE escape-expression

Use @% with the escape character clause:

select *from tblwhere fld like '%@%%' escape '@'

This will search for all records that contain the "%" character in the fld column.


DB2/z has a slightly different format:

select *from tblwhere fld like {escape '@'} '%@%%'

Obviously, you'll need to choose your escape character carefully so it won't interfere with the rest of your string but this is relatively easy for static strings. Dynamically built strings will require dynamically built queries so that it doesn't use a character from the string.

SELECT DISTINCT    COL2,     COL7,COL6FROM    TEST.IMPORTDATA1    WHERE         IMPORTDATA1.COL6 like '%@_10'  escape '@' 

SELECT DISTINCT    COL2,     COL7,COL6FROM    TEST.IMPORTDATA1    WHERE      IMPORTDATA1.COL6 like '%__10'  escape '_' 

参考如下：

Use @% with the escape character clause:

select *from tblwhere fld like '%@%%' escape '@'

This will search for all records that contain the "%" character in the fld column.

DB2/z has a slightly different format:

select *from tblwhere fld like {escape '@'} '%@%%'

Obviously, you'll need to choose your escape character carefully so it won't interfere with the rest of your string but this is relatively easy for static strings. Dynamically built strings will require dynamically built queries so that it doesn't use a character from the string.