... and small example

-- generate all tree
SELECT *
    FROM anytable
      CONNECT BY ParentID = PRIOR ObjectID


-- generate tree from any branch
SELECT *
    FROM anytable
      CONNECT BY ParentID = PRIOR ObjectID
       START WITH ParentID=25

MartiJ

>You're prolly in luck -- I'm not reading your question/scenario very closely, but Oracle has really good syntax specifically for recursion.
>
>(FYI: SQL Server is somewhat less good, but better in 2005 than it used to be.)
>
>If memory serves, you want to check out the STARTS WITH and CONNECT BY clauses.
>
>>L<