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
>
>