Remove Carriage Returns from Text Field 1

[NEveritt]

I am looking to remove carriage returns from a text field for 1800 records. I can find all rows that have carriage returns by the following query.

like '%' + Char(13) + '%'

But I need to know if there is a way to remove all the carriage returns and replace them permamently with a double space.

Help would be much appreaciated

N

 

[NathanGriffiths]

Hi,

When you say its a text field, do you mean its CHAR/VARCHAR datatype, or TEXT/ NTEXT datatype?

If its CHAR or VARCHAR, the following should work;

UPDATE <table>
SET <column> = REPLACE(<column>, char(13), ' ')


Nathan