Re: How can i store and retrieve strings with ' (Single quote) ??

From: Phil Herring <revdoc_at_uow.edu.au>
Date: 1997/12/02
Message-ID: <661vkg$q2u$1@wyrm.its.uow.edu.au>#1/1

In article <34844EA3.6A9A_at_ford.com> Bharat Yarlagadda, byarlaga_at_ford.com writes:
>Is there an escape char. that i can use to escape a ' in strings while
>storing the data. If there is any other way one could store and retrieve
>a single quote (') in varchar2 data type columns.

SQL> select 'I can''t see a problem with this' from dual;

'ICAN''TSEEAPROBLEMWITHTHIS'

---

I can't see a problem with this

---

Copyright 1997 Phil Herring. This article may not be reproduced for profit.

---

Received on Tue Dec 02 1997 - 00:00:00 CST