...given this dataset:

RowDate	RowId	CommentID
2/11/09	BB2	IL 5093
2/11/09	RO1	IL 5093
2/11/09	SL1	IL 5093
2/12/09	BB1	IL 9093
2/12/09	BB2	IL 9094
2/12/09	RO1	IL 9095
2/12/09	SL1	IL 9096
2/13/09	BB2	IL 9193
2/13/09	SL1	IL 9194

...to produce this result set?

RowDate	CombinedCommentId
2/11/09	IL 5093
2/12/09	IL 9093 IL 9094 IL 9095 IL 9096
2/13/09	IL 9193 IL 9194

The obvious attempt is to generate a concatenated field out of the individual CommentId fields for rows with common RowDate. The catch is to not repeat a CommentId that might exist on multiple rows with the same RowDate. My attempts so far have resulted with repeated values for 2/11/09 in the CombinedCommentId field, that is, IL 5093 repeats three (3) times while I only desire it to appear once as in the sample result set.

Thanks in advance.
Vince