Replace carriage return and line feed in a Text column?

Hi,

I've a text column (text datatype) that contains carriage return and line feed.

Syntax-wise, how can I replace these by a space?

Thanks.Hi,

I just got the answer. Thanks.

http://www.winnetmag.com/SQLServer/Article/ArticleID/20699/20699.html

SELECT
TextId,
replace ( replace(TextValue, char(10),
''), char(13), '') ModifiedTextValue
FROM
BadTextData