How about:
select *, iif(c > 0, c * 10, 99) as sort from mycur into cursor mycur2 order by a, sort, b desc
browse fields a, b, c
Regards,
Pieter
>hi all,
>i need to make index or select....
>thanks
>
>CREATE CURSOR mycur(A n,B n,C n)
>INSERT INTO mycur VALUES(1,42,2)
>INSERT INTO mycur VALUES(1,45,0)
>INSERT INTO mycur VALUES(1,23,4)
>INSERT INTO mycur VALUES(1,55,1)
>INSERT INTO mycur VALUES(1,70,0)
>INSERT INTO mycur VALUES(1,13,6)
>**********************
>INSERT INTO mycur VALUES(2,60,1)
>INSERT INTO mycur VALUES(2,80,0)
>INSERT INTO mycur VALUES(2,30,4)
>INSERT INTO mycur VALUES(2,20,0)
>INSERT INTO mycur VALUES(2,10,8)
>
>******************************
>i need result as
>a b c
>1 55 1
>1 42 2
>1 23 4
>1 13 6
>1 70 0
>1 45 0
>2 60 1
>2 30 4
>2 10 8
>2 80 0
>2 20 0
>
>
Pieter Runia
