Cindy and Dore,

How do your solutions result in the second example given? Looks to me like they would create the first example.

Dave

>>>If I have the following records in a table.
>>>

SID Desc  PID   LX
>>>1....A....0....0
>>>3....B....1....1
>>>5....C....3....2
>>>7....D....5....3
>>>8....E....14...3
>>>14...F....3....2
>>>21...G....3....2
>>>22...H....21...3

>>>
>>>and I want to sort so the table looks like a tree structure
>>>
>>>

SID Desc  PID   LX
>>>1....A....0....0
>>>3....B....1....1
>>>5....C....3....2
>>>7....D....5....3
>>>14...F....3....2
>>>8....E....14...3
>>>21...G....3....2
>>>22...H....21...3

>>>
>>>SID - Structure ID
>>>PID - Parent ID
>>>LX - Level in the tree
>>>
>>>Could this be done using a select statement? Any help or suggestion is appreciated.
>>>
>>>Thanks
>>SELECT * FROM sometable ORDER BY sid
>
>Or, in case there are some repeats in the other fields,

SELECT Sid, Desc, Pid, Lx ;
>  FROM MyTable ;
>  INTO CURSOR MyCursor ;
>  ORDER BY Sid, Desc, Pid, Lx

>
>Matthew - be sure to re-arrange the field names and ordering, and to test with enough repeating fields to get what you want.