Yeah that works great for this example, but the cit field can in this example be viewed as the subject field for the message and I don't want the message thread to be sorted alphabetically but rather but time of posting. the npk (and also nrk) fields implicitly tell me in wich order the posts (rows) where added to the table.
I could add a time field and record the message post datetime and use the same time value for all posts related to that message, but that seems like a waste of space.
I don't know if my problem makes sense.

Einar

>

>crea curs mycursor (npk i,nrk i, cit c(5))
>insert into mycursor (npk,nrk,cit) valu (1,1,"A")
>insert into mycursor (npk,nrk,cit) valu (2,1,"AA")
>insert into mycursor (npk,nrk,cit) valu (3,2,"AAA")
>insert into mycursor (npk,nrk,cit) valu (4,4,"a")
>insert into mycursor (npk,nrk,cit) valu (5,4,"aa")
>insert into mycursor (npk,nrk,cit) valu (6,6,"einar")
>insert into mycursor (npk,nrk,cit) valu (7,3,"AAAA")
>insert into mycursor (npk,nrk,cit) valu (8,7,"AAAAA")
>insert into mycursor (npk,nrk,cit) valu (9,5,"aaa")
>
>select * from mycursor orde by cit,nrk,npk
>