Sql Help...formatting Numbers.

[dotnetrockz]

[size="2"][color="#0000ff"][size="2"][color="#0000ff"]select[/color][/size][/color][/size][size="2"][color="#000000"] @bodyrecordcount[/color][/size][size="2"][color="#808080"][size="2"][color="#808080"]=[/color][/size][/color][/size][size="2"][color="#000000"] [/color][/size][size="2"][color="#ff00ff"][size="2"][color="#ff00ff"]count[/color][/size][/color][/size][size="2"][color="#808080"][size="2"][color="#808080"])[/color][/size][/color][/size][size="2"][color="#000000"] [/color][/size][size="2"][color="#0000ff"][size="2"][color="#0000ff"]from[/color][/size][/color][/size][size="2"][color="#000000"] #xx_tt ani query run chesthe result 5 vasthundhi...naku ila ravali...000005..any idea?[/color][/size]

[Ranga_The_Donga]

count(RIGHT('00000'+ CONVERT(VARCHAR,Num),6))

[dotnetrockz]

[quote name='Jeedeelu' timestamp='1320173862' post='3054236']
count(RIGHT('00000'+ CONVERT(VARCHAR,Num),6))
[/quote]

thanks...

[k2s]

[quote name='Jeedeelu' timestamp='1320173862' post='3054236']
count(RIGHT('00000'+ CONVERT(VARCHAR,Num),6))
[/quote]