Removing hidden CRLF from a string in MS SQL Server

Sometimes in SQL string the hidden CRLF character looks like a blank space, but when we copy/paste it into MsWord, we can see that CLRF characters.

To remove this hidden CRLF charcter:

UPDATE dbo.MyTable SET MyColumn = REPLACE(MyColumn,CHAR(160),'')  

Leave a Reply