SQL & PL/SQL

Hi,

I have a datafix where I wish to update all rows for a particular column which have new line character (CHR(10)) within to remove the new line character. I cannot do this with RTRIM, the following returns the string not trimmed:

select RTRIM('12345'||CHR(10)||'next', CHR(10)) from dual;

Why does the above not work? How would I implement the above by specifying string: '12345'||CHR(10)||'next' and removing the new line character and remaining data on new line?

Thanks for your help.