Given the following variable:
declare @str nvarchar(50) = 'abc'
between 'a' and 'b' there is a hidden character which is:
select len(@str) --4
select unicode(SUBSTRING(@str,2,1)) --8207
my problem is that I have many such records, and I have to find all these characters and delete them.
I'm trying find by
REPLACE but it just does not recognize this character:
select CHARINDEX(Nchar(unicode(8207)),@str) --0
select REPLACE (@str , Nchar(unicode(8207)), '1') --abc