Dear Experts

SELECT FDATE,GNO AS PARTY;
FROM WEIGHTS;
WHERE FDATE=THIS.VALUE ;
ORDER BY PCODE;
GROUP BY PCODE;
INTO cursor fix
The select statement generate folloiwng SQL Results

25-09-2006------2
25-09-2006------5
25-09-2006------6
25-09-2006------8
25-09-2006------7

But I want to get following result

25-09-2006------2,5,6,7,8

Please help
--------------------------------------------------------------
You can use an UDF in select statement to realize string sum.