remove '&' character from a string
798344Sep 16 2010 — edited Sep 16 2010Hi,
I need to remove '&' from a string.
example:
string = 'HH&GG',
desired result = 'HH GG' OR 'HH,GG'
Tried 'replace', 'substr' functions, along with 'set ESCAPE '&'.
They don't work. '&' is treated as an input place holder. How can replace/remove an '&' from a string?
Thanks,
Radhika.