Excellent method of placing an index on a UDF.

However the 32 level limit of UDF's is annoying when we have a recursive relationship.

I have recently been looking at the nested set model and this seems to have a lot to offer if the recursive level goes beyond 32.

Takes a little bit of thought though 🙂

cheers

martin