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