Asked By Aaron Bertrand [SQL Server MVP]
04-Apr-07 12:32 PM
SELECT REPLACE(REPLACE(REPLACE(column_name, CHAR(10) + CHAR(13), ' '),
CHAR(10), ' '), CHAR(13), ' ')
FROM table_name
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006