Re: SELECT a field with special chars. like a \'

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1998/03/20
Message-ID: <3514c497.1834618@192.86.155.100>#1/1

A copy of this was sent to Peter Smith <psmith01_at_mindspring.com> (if that email address didn't require changing) On Thu, 19 Mar 1998 19:25:02 -0500, you wrote:

>I need to do the following:
>
>Select * from <some_oracle733_db_on_nt> where <somecolumn> =
>'<some_value>'
>
>The problem I'm having is that '<some_value>' may be "D'Angelo" which
>yields:
>
>Select * from <some_oracle733_db_on_nt> where <somecolumn> = 'D'Angelo'
>
>thus producing a syntax error. What's the work-around??
>
>Thanks.
>
>--Peter--
>psmith01-at-mindspring.com
>

select * from T where C = 'D''Angelo';  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Fri Mar 20 1998 - 00:00:00 CST