Hi Sam,

Assume that the column c1 of table TEST has carriage return(s) which you want to eliminate:

select REPLACE(c1,chr(10),' ') from TEST;

replaces all the carriage returns i.e, chr(10) values with a space.