I know that this is a strange one, but I need to know how to generate a SQL that will allow me to concatenate multiple values within a single field into a single record separated by ",".

I have to take a field called category with several entries based on a single ID and concatenate them into a single record so I can import the record into MS Outlook.

ID Category
1 Safety
1 Industrial Hygiene
1 Environmental

This now must be:

ID Category
1 Safety, Industrial Hygiene, Enviro

------------------
Dick Franklin