SQL Server trim function

Question

I have a problem in SQL Server. I want to remove space using Ltrim and Rtrim.

My query is like this

select len('test        ')

Return 6

select len(rtrim(ltrim('test        ')))

Return 6

Why Its not Removing space?

I have checked the ascii values for this space is 32.

Any help?

Thank you

Answer 1

Because there are no spaces in this string - after test there are two horizontal tab characters (\t).