I want a output file comma delimited as shown below:

ABC,123,45,TEST

I will be using the xp_sendmail to automatically e-mail this attachment out.
Using the @separator=`,` with the xp_sendmail gives me an extra `,` at the end of the file and when I put the `,` in between the columns selected myself(ie AccountNumber, `,`, Quantity, `,`, etc...) I am left with huge amounts of white space between each column(even after using an RTRIM()).

I want to be able to get a file just like when you set the Result Output Format in the Query Options to Comma Delimited!!!!!

Any hidden tricks I do not know about?