very interesting. I too thought the results would be "1, 2,". Until I set the output to text and realized I was wrong.
I thought the final select would "automatically" trim the trailing space since the field type was set to varchar. Again very interesting....