thank you very much it works,

>>hi all,
>>i get result from table mucurtw as ex..
>>

>>empnam,empno, typ1,total_cfil
>>a       1     20    1
>>a       1     20    3 
>>a       1     20    1
>>a       1     20    2
>>a       1     18    10 
>>a       1     18    32
>>b
>>b
>>c
>>c
>>..
>>..
>>***********************
>>i need result from table mucurtw to new table or cursor sum typ1 and count typ1 it all fields is CHR type as..
>>empnam,empno, typ1,newtotal_cfil,count1
>>a      1      20      7            4
>>a      1      18      42           2
>>.
>>.
>>
>>

>>thanks
>
>

>SELECT empnam, empno, typ1, ;
>               CAST(SUM(total_cfil)  AS C(20)) as Newtotal_cfil, ;
>               CAST(CNT(*) AS C(20))AS count1 ;
>  FROM mucurtw ;
>  GROUP BY empnam, empno, typ1 ;
>  INTO CURSOR csrResult
>

>
>Tamar