Yes, it's possible and easy to do. Give me a sec. to find relevant info.

>...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