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.