Problem With Stored Procedure Output

I am new to SQL server - Would appreciate any help.

I have a stored procedure (A) that creates a temp table with a single field of varchar(1000).

I populate this table with string data and with contents of another table obtained via the use of a cursor.

In a nutshell I am creating an XML document representation where each line of the temp table is a line of the xml document.

At the end of the stored procedure I select all of the fields from the temp table.

I have another stored procedure (B) that uses xp_sendemail and uses stored procedure (A) as the query for the attachment.

The problem is that the attachment appears to contain all unicode characters and will not open in windows explorer. It will open in XML SPY and other XML editors.

If I look at the data in a simple editor such as editplus, I see that each chracter is followed by a null character which is why I am assuming it is unicode.

Any idea how to get the select output / email attachment to exclude these null characters?