I don't think this has anything to do with RTRIM, you just need to change the way the results are displayed in Query Analyser. Go to the Tools menu, select Options, then in the Results tab change the Results Output Format from Column Aligned to CSV. You will then get your output without the padding that is required to align the columns.
HTH