>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,",")