To search for employees with the pattern 'A_B' in their name:SELECT last_name
FROM employees
WHERE last_name LIKE '%A\_B%' ESCAPE '\';so, you can select * from yourtab where yourcol like '%\%%' ESCAPE '\';
FROM employees
WHERE last_name LIKE '%A\_B%' ESCAPE '\';so, you can select * from yourtab where yourcol like '%\%%' ESCAPE '\';
----------------------------
5SQL>