Can you pls. run the below query?

SELECT CHARINDEX(CHAR(9),Column4, 0) FROM [server].[db].[dbo].[view]

Do you get values other than 0 in the result set? If yes than you don't have trailing spaces but tabs in Column4 values. RTRIM and LTRIM do not trim tabs. You may want to replace tabs with empty strings. That's the only thing I can think of.

-Supriya

EDIT: Also look for Line feeds( char(10) ) and Carriage returns ( char(13) ).