how to search for rows containing special charactors, ', ", \

Special charactors in the data entry cause problems (C++/Java) call client. I am trying the clean up the data containing the special charactors interpreted differently in C/C++/Java etc, such as single quote ', double quote ", backslash \.

Oracle SQL reference manual shows how to do it for special charactor underscore "_":
select * from my_table where job_desc like '%\_%' ESCAPE '\';

But this does not work for "'", """, "\", etc ...

Philip Received on Fri Jan 19 2001 - 10:19:18 CST