Great, thanks to both of you for the help!

Nice, I'll see if I can translate that to my, much more complex, query. Thanks for taking the time to help me!!

Thank you, folks! I have it licensed thru SBS so we'll have to figure out what our next step is.

Thanks, Vick. I'm newbie here so happy to see a standard to use.

Provided the test script below, adding the FOR XML AUTO at the end of the...

I appreciate all the help!

Thank you very much! That will work just fine.