Replace / Remove a newline or carriage return in T SQL

REPLACE({String}, CHAR(13)+CHAR(10), '')

Source:http://stackoverflow.com/questions/951518/replace-a-newline-in-tsql