You are all over the place here. As xsevensinzx said, some examples/visuals would be helpful. Also, a better explanation of what you mean by, "Up until now, we used a...

Everyone...

SQL Server is so weird sometimes. 

select 'a'+++++++++++++++++++++++'b'++++++++++++++++++++++++'c'
returns abc.

I don't fully understand the req but here's some sample data and some t-sql code which might point you in the right direction. 

-- sample data
declare @order...

As drew said, you are likely dealing with a non-space whitespace character; what Luis posted will help you identify what that character is. 

This can easily be resolved using...

Expanding on Jeff's comments - this is one of those things that's worth understanding as FOR XML can be a complicated topic. Wayne Sheffield's article, Creating a comma-separated...

I'm not a DBA anymore (SQL Developer.)  In high school I was studying to be an artist but chickened out only because of fear that I would not make any...