Thanks to both of you for your replies! This did help a bit in getting it more into the format I needed. I was tired of trying to juggle XML with those first few lines, so I turned to good old CONVERT to varchar and REPLACE. 🙂
Appreciate the help!
Thanks,
Jessica
What would you attempt to do if you knew you could not fail? -Robert H. Schuller