Hi,
Try this...
--------------------------------------------------------
DECLARE @lValueStr VARCHAR(MAX)
SET @lValueStr = NULL
SELECT @lValueStr = COALESCE(@lValueStr + ', ', '')
+ name + '(' + CAST(Counts AS VARCHAR(5)) + ')'
FROM Test T
SELECT @lValueStr
---------------------------------------------------------
Shaiju C.K.
_____________________________________________
One ounce of practice is more important than tonnes of dreams