Replace with '

[#1]

Hi,

   I need to replace a character with '. Please help me on this. Below is the example

   replace(children**s,'**',''')

   output should be children's

  Anybody??

Thanks,

Ravi.

[Gysbert_Wassenaar]

Try: replace('children**s','**',chr(39))

[#3]

Wonderful. Thanks for the quick response, Its working