Trim spaces in string - LTRIM RTRIM not working

Question

I tried this code - ``` UPDATE Table SET Name = RTRIM(LTRIM(Name)) ``` Data type of Name is `varchar(25)` None of the leading and trailing spaces get removed. When I copy-paste one such `Name`, i get this - ``` "big dash" "space symbol" ABC001 ``` Why is this happening and how do trim the spaces ? EDIT - The question has already been answered. I found one more table with this problem. I get "- value" when i copy a column of a row. When I press the enter key at end of this copy-pasted value, i see more dashes. See image below -

Accepted Answer

I suspect, some non readable(Non-ascii characters) inside the name column, that might not get removed as part of `TRIM` calls.

```
select convert(varbinary, Name) from table
```

Reading the `HEX` output from above query should reveal the same.

Kindly read this to find how to write functions to remove such characters.

Trim spaces in string - LTRIM RTRIM not working

Solution

Problem