Escape percentage sign DB2 SQL
Use @%
with the escape character clause:
select *
from tbl
where fld like '%@%%' escape '@';
select * from tbl where fld like '%@_%' escape '@'
Escape percentage sign DB2 SQL
Use @%
with the escape character clause:
select *
from tbl
where fld like '%@%%' escape '@';
select * from tbl where fld like '%@_%' escape '@'