help on manipulating a string !!

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')...

1. 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