Regarding the reply by aschoch: I'm not sure how your suggestion works...you mentioned that you ran this query:

SELECT CONVERT(xml, '') AS DataXML FROM MyTable

However, I don't see a column reference in that query. Can you explain how this works in a bit more detail? I'm very interested in seeing if XML technology can replace what I'm doing with a simpler script.

Thanks,

SB