I'm trying to remove carriage returns and line feeds from a column I imported from a csv file.
I'm using the code:
SELECT replace(replace(column,CHAR(13),''),CHAR(10),'')
FROM table
It correctly finds all the CR and LF, but it doesn't update the database.