connect by prior

Hello,
I have to migrate an application from oracle to sqlserver but i habe query with
connect by prior
What is the equivalent in sqlserver 2000.
Please help me.The CONNECT BY PRIOR syntax is an Oracle (and now DB2) specific add-on to the SQL-92 standard. Similar functionality is comming in Yukon, the next version of SQL Server, but for now you can write a User Defined Function in SQL-2000 to get the same effect.

-PatP|||The CONNECT BY PRIOR syntax is an Oracle (and now DB2)
-PatP

Not if you're stuck with V7 on OS/390...

Give me a big block V8 PLEASE!