sql delete specific unicode chatacter

I want to delete specific unicode character ୍ nchar(2893) from column in a table. Sample is below.

введите сюда описание изображения declare @str nvarchar(max) = N'email shortly.© 2020 certificationplanner ୍Employer Sponsored Learning ୍Guarantee to run bootcamp'

select replace(@str, N'୍', '')

But it is not working. characters still remain. What is wrong here?


Ответы (0 шт):