chrisacron wrote:

> In my application I use a self-related table to define complex
> classifications. The number of levels are theoretically unlimited but
> in reality will probably be 10-15 maximum.
> Is there another way of doing this?

Write a recursive stored procedure?

With recursive SP you are not limited and go to any depth (or whatever
is the limitation of stack space).

--
Milan Babuskov
http://swoes.blogspot.com/
http://www.flamerobin.org