apostrophe

From: <simpatel_at_hotmail.com>
Date: Fri, 21 May 1999 22:45:24 GMT
Message-ID: <7i4nm4$hph$1_at_nnrp1.deja.com>



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 - 00:45:24 CEST

Original text of this message