InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 05:59:32 GMT20http://www.sqlservercentral.com/Forums/Topic1404599-391-1.aspxThis should work, there are other ways as well [code="sql"]CREATE TABLE #Id( Id int)Insert into #IdValues (10),(12),(9),(15),(8),(4),(100),(29)Select Id,Right('000'+Convert(varchar,Id),3) from #Id[/code]Wed, 09 Jan 2013 01:49:15 GMTJason-299789http://www.sqlservercentral.com/Forums/Topic1404599-391-1.aspxhi friens i have small doubt in sql server.plese tell me how to solve this issuse.table data contains like id 10 12 9 15 8 4 100 29i want output like id 010 012 009 015 008 004 100 029 .plese tell me how to write query in sql serverWed, 09 Jan 2013 01:42:08 GMTasranantha