InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 06:30:50 GMT20http://www.sqlservercentral.com/Forums/Topic1403502-145-1.aspxHiDifficult without a little more information however this may point you in the right direction[code="sql"] declare @table as table (id int) INSERT INTO @table SELECT 100 UNION ALLSELECT 101 UNION ALLSELECT 102 UNION ALLSELECT 103 UNION ALL SELECT 104 SELECT STUFF((SELECT ',' + CAST(id AS VARCHAR (3)) FROM @table t1 ORDER BY t1.id FOR XML PATH('')),1,1,'')[/code]AndyMon, 07 Jan 2013 03:36:25 GMTAndy Hyslophttp://www.sqlservercentral.com/Forums/Topic1403502-145-1.aspxIn my table i have following result setssno101102103105106107i want following structures101,102,103,105,106,107Mon, 07 Jan 2013 02:55:28 GMTvs.satheesh