This select yields the results below. rtrim doesn't seem to trim the last character. I'm wondering if rtrim removes spaces but not tabs or something.
select len(loginwindows) as loginlen, len(rtrim(loginwindows)) as loginlenrtrim, left(loginwindows, 8) as login8, loginwindows from general.employees where lastname = 'langley'
loginlen loginlentrim login8 loginwindows
9 9 LL004838 LL004838