well, so far it looks like a single offending character, so i think you can do a simple replace();

if this produces the desired name , i would update it with the

sample below:

select

id,

name,

REPLACE(name,CHAR(0),'') As Fixed

from my_user_table

--only bad data for clarity

WHERE CHARINDEX(name,CHAR(0),1) > 0

If that's cleaning up the results correctly, a simple replace should fix it:

UPDATE my_user_table

SET name = REPLACE(name,CHAR(0),'')

--only bad data for to match the #rows in our original select

WHERE CHARINDEX(name,CHAR(0),1) > 0