Jeremy,

Thanks for the reply. Sorry I am responding late but you know how it goes, one problem to the next and all that.

Took me a little bit to wrap my brain around your solution but it got me to look at "STUFF" and "FOR XML PATH" which are very useful. Which Holiday Inn Express did you stay at, I think I need to be there for a week 🙂

This works quite well for the simple sample I set up but as I started getting some real data from the user it's gotten a bit more complicated and I started down a different path. I think I am going to create a function that does the work and returns a varchar. I am leaning this way because I have a feeling the requirements for the "instructions" will be changing often and if it does I just have to modify the function. I suspect I will take a performance hit but this will be part of an "off hour" job.

No problem for the sample data. Your guys are doing me a favor, the least I can do is make easier. Besides I saw Jeff Moden's post about "questions etiquette" and he made it so simple to put it together I would have felt guilty if I didn't.

Thanks again,

Craig