RE: quote in string

From: larry elkins <elkinsl_at_flash.net>
Date: Wed, 27 Sep 2000 18:28:08 -0500
Message-Id: <10632.118091@fatcity.com>

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   2 /

REPLACE(TICKY,'''','XYZ') Received on Wed Sep 27 2000 - 18:28:08 CDT