From: <simpatel_at_hotmail.com>
Date: Fri, 21 May 1999 22:41:07 GMT
Message-ID: <7i4ne3$hmn$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.

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Sat May 22 1999 - 00:41:07 CEST

Original text of this message