Is there an alternative for nesting REPLACE() functions when replacing multiple strings? Even a simple removal of CR and LF results in REPLACE(REPLACE(data,CHAR(13),'~'),CHAR(10),'~'). Now imagine a dozen replacements .....
Is there an alternative for nesting REPLACE() functions when replacing multiple strings? Even a simple removal of CR and LF results in REPLACE(REPLACE(data,CHAR(13),'~'),CHAR(10),'~'). Now imagine a dozen replacements .....