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

From: Matthew Fuller <matthewlf_at_my-deja.com>
Date: Fri, 19 Jan 2001 20:18:02 GMT
Message-ID: <94a7dg$20u$1@nnrp1.deja.com>

In article <949pe6$pjq$1_at_watserv3.uwaterloo.ca>, szhan_at_calum.csclub.uwaterloo.ca (Philip S Zhan) wrote:
>
>
> 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
>
>

You can find single quotes with the following:

JOB_DESC LIKE '%''%' The others should work as normal, i.e.

JOB_DESC LIKE '%"%'
JOB_DESC LIKE '%\%' etc.

HTH. Matt.

Sent via Deja.com
http://www.deja.com/ Received on Fri Jan 19 2001 - 14:18:02 CST