RE: quote in string

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Thu, 28 Sep 2000 08:30:10 -0400
Message-Id: <10633.118133@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C02947.D7ADF976

Content-Type: text/plain;

        charset="iso-8859-1"

Larry, again you have been so helpful. Very clever! Thanks for your response.
Lisa

-----Original Message-----

From: larry elkins [mailto:elkinsl_at_flash.net] Sent: Wednesday, September 27, 2000 8:26 PM To: Multiple recipients of list ORACLE-L Subject: RE: quote in string

Lisa,

You already have a workaround; but, here is how you can handle it in a REPLACE. You don't mention what you want to replace it with; but, the same concept applies:

SQL> select * from ticky;

TICKY

---

O'Connor

SQL> select replace(ticky,'''','''''') from ticky;

REPLACE(TICKY,'''','

---

O''Connor

SQL> select replace(ticky,'''','XYZ') from ticky Received on Thu Sep 28 2000 - 07:30:10 CDT