Jeff,

Your suggestion with the function almost worked except that I have to work with a temporary table and so I can't use the function.

I have been trying to avoid the FOR XML function because it looks really complicated in sql 2000.

Any other suggestions?