For some SQL queries, we need to search for strings containing special characters like '%'.
- Considering the below example, the need is to find records containing the middle character '%':
where fields like '%%%';
- To do this you must know how to seperate the special characters.
- First of all we must give a value to SQL ESCAPE parameter, for example '^':
SQL>SET ESCAPE ^
- From there, the character '^' can be used to identify and seperate special characters.
where fields like '%^%%';