This script will give you a comma separated (or semicolon separated) list in SQL Server 2005 SELECT c.sopnumbe, STUFF ( ( SELECT ',' + CAST (itemnmbr AS VARCHAR ( MAX )) AS [ text ()] FROM ( SELECT DISTINCT rtrim (itemnmbr) as itemnmbr FROM sop10200 AS O WHERE O.sopnumbe = C.sopnumbe) AS D ORDER BY itemnmbr...