You would need to create a UDF to replace the CR/LF with a single blank. If you are ok with turning each occurance of them into blanks, i.e. each CR becomes a blank AND each LF becomes a blank, you can use the TRANSLATE function as such TRANSLATE(col,' ',concat(chr(10),chr(13)))
Originally posted by bpoulain
The CR/LF characters are in as string which is in a column. How do you do to replace CR/LF by a space ?