Incidentally, here's the code that is being used. The folders table has folderid, foldername, and parentid fields that determine names and heirarchy. When the parentID value is 0, that's...

Sean,

I tried that using the Stored Procedure but couldn't get it to work. Are you saying it would have worked if the logic had been in an inline Table...

Luis,

I used the first example you provided. Thanks for the help. I owe you a good lunch if you are ever in Salt Lake City, Utah, USA.

Jerry

Luis,

I was hoping to have a seperate Stored Procedure to give me just the folder names that I would be able to use in other areas. I had even...

Sean,

Thanks for replying. I don't use prefixes myself but the errors/nonexistent data I was was seeing caused me to try things such as changing names, etc.

Jerry