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?