See function REPLACE() in BOL

SELECT REPLACE('abc' + CHAR(13) + 'dfdks', CHAR(13), SPACE(1))

>I need to Select a data from a field in a database, but the field has many chr(13) in it.
>
>i need that the data from the field comes out without the chr(13)

--sb--