>Hi all
>
>Is there any way with SQL Server and SPT to concatenate a set of entries into a string much as SUM() sums a set of entries into a total?

Mike,
There's set based solution if you want to concatenate column from all records that satisfy query conditions.

TEXT TO lcSql NOSHOW
DECLARE @StrConcat varchar(8000)
SET @StrConcat = ''
SELECT  @StrConcat =  @StrConcat + ', ' + title_id
	FROM pubs..sales
	WHERE stor_id LIKE '7%'
SELECT SUBSTRING(@StrConcat,3,8000)
ENDTEXT
? SqlExec(lnConn, lcSql)