Remove line breaks with SQL

To remove line breaks using SQL see example:

SELECT REPLACE(MyField, char(13) + char(10), ' ') FROM MyTable