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

select EmpName, EmpNo, typ1, sum((cast Total_cFil as int)) as NewTotal_cFil, count(Total_cFil) as Count1 ;
from mucurtw ;
group by EmpName, EmpNo, typ1