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),'')
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),'')