SQL command not changing data

Answer 1

You need to use an UPDATE statement!

The replace in the SELECT just changes the output not the data in the table.

BEGIN TRAN
UPDATE Customers SET Address = REPLACE(Address, char(10) + char(13), ' ') .... etc

--Check you like the change
SELECT * FROM Customers
--COMMIT --uncomment this to commit the changes.

Answer 2

hi, the problem is the when first replace is completed in the text char(10) and char(13) are replaced with ' ' and the next replaces nerev do nothing

Answer 3

UPDATE Customers
   SET Address = REPLACE(.....)

Answer 4

When you perform a replace inside a select only the data "selected" is changed. So the replace is done just before showing you the data. The table data is not touched by a select. The data in the column needs to be updated via an update statement like:

UPDATE customers SET
    Address = REPLACE(Address,CHAR(10)+CHAR(13), ' ')

Answer 5

That would be:

UPDATE customers SET Address = REPLACE(REPLACE(REPLACE(Address,CHAR(10)+CHAR(13),' '),CHAR(10),';'),CHAR(13),';')