apostrophe

From: <simpatel_at_hotmail.com>
Date: Fri, 21 May 1999 22:45:11 GMT
Message-ID: <7i4nln$hpb$1@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 Fri May 21 1999 - 17:45:11 CDT