Replace newline in SQL

replace(sourcestring, E'\n', ' ')