InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 00:39:03 GMT20http://www.sqlservercentral.com/Forums/Topic1407037-391-1.aspxThanks Experts Its work !Tue, 15 Jan 2013 21:33:46 GMTkiran.rajenimbalkarhttp://www.sqlservercentral.com/Forums/Topic1407037-391-1.aspxOr like this:[code="sql"]SELECT CASE num WHEN 0 THEN '' ELSE 'D' END + RIGHT(num*POWER(10, 3-FLOOR(LOG10(CASE num WHEN 0 THEN 1 ELSE num END))), 4)FROM abc[/code]What??? :-PTue, 15 Jan 2013 01:59:55 GMTdwain.chttp://www.sqlservercentral.com/Forums/Topic1407037-391-1.aspx[code="sql"]SELECT 'D' + LEFT(CAST(num AS VARCHAR(4))+'0000',4) FROM abcSELECT ISNULL('D' + LEFT(CAST(NULLIF(num,0) AS VARCHAR(4))+'0000',4),'0') FROM abc[/code]Tue, 15 Jan 2013 01:35:24 GMTChrisM@Workhttp://www.sqlservercentral.com/Forums/Topic1407037-391-1.aspxHi Professional ,Create Table,[code="sql"]CREATE TABLE abc(num int)[/code]Insert Into [code="sql"]insert into abc values (1010)insert into abc values (111)insert into abc values (99)insert into abc values (0)[/code][code="sql"]SELECT 'D'+ CAST(num AS NVARCHAR) FROM abc[/code]Now I am getting Result as below,D1010D111D99D0But I have to show result as like below,D1010D1110D99000So please suggest me how to do this ?Regards,KRAjMon, 14 Jan 2013 23:26:06 GMTkiran.rajenimbalkar