Khubaib;
try something like

SELECT;
 Cur1.Category,;
 COUNT(*) AS nCount;
 FROM YourCursor AS Cur1;
 INTO CURSOR curCount;
 WHERE Cur1.Category=='A';
 GROUP BY 1

Agnes
>in my filed (category) records as=A,B,C,A,A,A
>I want to count the records.
>if A,A,A is replaced continuously

>SELECT date,code,lcode,sec, ;
> CAST(sum(IIF(category=="A",1,0)) AS I)	A is 3