Re: apostrophe

From: Dante <dnotari_at_my-dejanews.com>
Date: Tue, 25 May 1999 10:55:09 GMT
Message-ID: <7idvid$k98$1@nnrp1.deja.com>

Sachin,

try

update table set column = 'ABC'''s XYZ'

Regards
Dante

In article <7i4nln$hpb$1_at_nnrp1.deja.com>, simpatel_at_hotmail.com wrote:
> Hello All,
>
> You must have been through this one, one time or another! How do you
> allow users to put an "'" (APOSTROPHE) in a varchar2 field? e.g.
> update table set column = 'ABC's XYZ'.
>
> One option I know is, putting 2 apostrophes. Another would be to
parse
> it in application before issuing an SQL statement.
>
> Would you please "enlighten". Direct response will be appreciated.
>
> thank you in advance.
> sachin
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 25 1999 - 05:55:09 CDT