help on manipulating a string !!

From: deb <dnanda_at_netcom.ca>
Date: Wed, 19 May 1999 20:46:24 -0400
Message-ID: <uhJ03.41144$134.367324@tor-nn1.netcom.ca>

I want to create a procedure which takes a special string as an input.Please note that the input string may have an apostrophe (').If there is an apostrophe in the string then it will insert another one immediately following the previous one... for example

the string ('mike o'grady') should be converted to ('mike o''grady')...

Another thing that I wanted to know if oracle can accept special characters like '&' and ' in a string.

thanks /dip Received on Wed May 19 1999 - 19:46:24 CDT