Using SQL Server to replace line breaks in columns with spaces -

i have large table of data of columns contain line breaks. remove them , replace them spaces instead.

can tell me how in sql server?

thanks in advance

this should work, depending on how line breaks encoded:

update t     set col = replace(col, ' ', ' ')     col '% %'; 

that is, in sql server, string can contain new line character.