Remove this SEP L-tag using SQL?

Question

There is a character in the string that I cannot remove from the StringBuilder.

------>

-4

Programmer 05 oct. 16 at 21:33

1 answer

Shnugo · Accepted Answer · 2016-10-05T21:38:33+0000

This character UNICODE 8232

is called the line separator. More details here

As long as you're dealing with NVARCHAR

, it's easy to replace

DECLARE @string NVARCHAR(100) = N'Between x and y is your character x y';

SELECT REPLACE(@string,NCHAR(8232),''); --nothing between x and y anymore...