Re: apostrophe

From: XU <xux_at_informa.bio.caltech.edu>
Date: 23 May 1999 02:19:02 GMT
Message-ID: <7i7oim$rjh@gap.cco.caltech.edu>

use two "'". i.e. set column = 'ABC''s XYZ'

Robert XU

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.---
Received on Sat May 22 1999 - 21:19:02 CDT