I tried this code -
SET Name = RTRIM(LTRIM(Name))
"big dash" "space symbol" ABC001
I suspect, some non readable(Non-ascii characters) inside the name column, that might not get removed as part of
select convert(varbinary, Name) from table
HEX output from above query should reveal the same.
Kindly read this to find how to write functions to remove such characters.