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

Bharat Yarlagadda wrote:

> 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.

Yes. it is the ' itself eg.

insert into taba(varch_fld) values ('I''ve got a quote in!')

Cheers,

Ian Received on Fri Dec 05 1997 - 00:00:00 CST