Thanks to Tore and Rich

Adding AS prog_long solved the problem

Moises



>>Hi Rich
>>
>>I replaced it as you said:
>>
>>SELECT GETWORDNUM(Prog_long,1,",") , COUNT(*) AS Quant FROM reembolso GROUP BY prog_long where reembolso.date > DATE()-thisform.days.value INTO CURSOR crsReemb ORDER BY quant DESC
>>
>>But I got the error message "variable not found".
>>
>

SELECT GETWORDNUM(Prog_long,1,",")  AS prog_long ,  COUNT(*) AS Quant;
>  FROM reembolso;
>  WHERE reembolso.date > DATE()-thisform.days.value;
>  GROUP BY 1;
>  ORDER BY quant DESC; 
>  INTO CURSOR crsReemb

>
>
>
>>It seems the command is not accepted in a line, or am I doing something wrong ?
>>
>>Moises
>>
>>
>>>>I am using the code below to group results,but the problem is that some records have a comma which duplicates some results
>>>>
>>>>eg:
>>>>
>>>>Yellow
>>>>blue
>>>>blue,
>>>>green
>>>>red
>>>>red,
>>>>
>>>>Is there a way to remove the comma only from the the result of the code below without removing the commas from the original table ?
>>>>
>>>>
>>>>SELECT Prog_long , COUNT(*) AS Quant FROM reembolso GROUP BY prog_long where reembolso.date > DATE()-thisform.days.value INTO CURSOR crsReemb ORDER BY quant DESC
>>>
>>>Try......
>>>

GETWORDNUM(myfield,1,",")