>Hi,
>
>If I have the following records in a table.
>and I want to sort so the table looks like a tree structure
>
>Could this be done using a select statement? Any help or suggestion is
>appreciated.

Try asking on news://msnews.microsoft.com/microsoft.public.sqlserver.programming -- I'll bet someone there could tell you.