>After I posted a message I think that You should have something like this You describe now. So that's because I posted a new one. W/o a UDF, I think, that can't be done. But let's hope a SQL masters will invent something.

Thanks for the UDF. I think that you gave me a push in the right direction. To make things faster I'll create a temporary cursor. The temporary cursor will contain what I describe as "the whole path"

for example I'll start with the categories defined by the user and build my temporary cursor.

So after that it'll only be a matter of getting descriptions that were defined in the temporary cursor.

So if I start with my previous example with

"75"         = "Movies"
"7501"       = "DVD"
"750102"     = "Comedy"
"75010203"   = "2005"
"7501020304" = "Robin Williams"

My temporary cursor would become

"75"         = "Movies"
"7501"       = "Movies, DVD"
"750102"     = "Movies, DVD, Comedy"
"75010203"   = "Movies, DVD, Comedy, 2005"
"7501020304" = "Movies, DVD, Comedy, 2005, Robin Williams"

So I'd be all set creating the necessary cursor for my report. Does this make sense to you?