Using T-SQL REPLACE (or XML) To Add An Attribute To Every Other &&<td&&> Tag

I have the following as part of a stored procedure that generates an HTML report based on the data inserted into the table variable "@tblTemp":


SET @html =

N'<table border="1" width="0" style="font-family: Verdana, sans-serif;">' +

N'<tr><th>Name></th><th>ID</th></tr>' +

N'<col align="left"></col><col align="right"></col>' +

CAST ( ( SELECT td = [Name], '',

td = IDNumber

FROM @tblTemp

ORDER BY ID

FOR XML PATH('tr'), TYPE

) AS NVARCHAR(MAX) ) +

N'</table>' ;

SET @html = @html + N'<br /><br /><img src="muuscreenshot.jpg" width="452" height="507" alt="sample.aspx" />'

This generates a 2 column table that later in the stored procedure is sent out via sp_send_dbmail. The problem I'm having is that I want the right (2nd) column of the table to be right-aligned. For some reason, the line "

N'<col align="left"></col><col align="right"></col>' +" doesn't right-align the 2nd column when the report is sent through email (althought it does work if I take the generated string a use it to manually create an HTML file). So I want to add something like:

SET @html = REPLACE(@html, '<td', '<td align="right"')


but I still want the left column to be left-aligned, and this right-aligns everything. Is it possible for me to use REPLACE (or some other string function) to replace every other (alternating) "<td", or should I be looking at parsing this string using some 2005 XML features (unfortunately, using a CLR function to do this is not an option, since I am not allowed to turn that on on the server I'm using)? Thanks in advance.

-Dave