Hi Mohammed,
INDEX ON PADL(A,11,'0')+IIF(C=0,'99999999999',PADR(C,11,'0'))+IIF(C=0,PADR(B-99999999999,11,'0'),PADR(B,11,'0')) TAG I01
MartinaJ
>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
>
>
