>Hi Hilmar
>
>>I think you will just have to create a UDF that goes all the way to the root and counts the levels.
>>
>>You might also consider saving the level as part of the data, to avoid those searches.
>
>Thanks for your suggestions. I was hoping there was a SQL statement that would yield the level no.
I don't think so. Of course, once you have the appropriate UDF, you can call it from a SELECT statement.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)