>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)
--sb--