Help Formatting Number

[RichardParry]

Hi All,

I wonder if you guys can help - I have a standard integer field returning numbers ranging 1 to 10, however I need to format single integers 01, 02, 03, 04, 05, 06, 07, 08, 09, 10 etc. I tried this using the Decimal function within T-SQL, but pretty sure the reason this isn't working is because of no decimal in the integer

I could do this in VB with FormatNumber easy, but unfortunately this is purely a T-SQL exercise (View).


Thanx!!! Richard

 

[gmmastros]

Numbers cannot have a leading 0. It can't be done.

However, if you convert the number to a varchar, you can accomplish your goal.

Select Right('0' + Convert(VarChar(2), ColumnName), 2)
From   TableName

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[RichardParry]

Thank you again George!!!

 

[LNBruno]

If stars were pennies, George....

< M!ke >
[small]I can say nothing, which is cowardly, I can lie, which is immoral, or I can tell the truth, which will upset people. - Tiki Barber[/small]

 

[nice95gle]

>> If stars were pennies, George....

...would be very poor. Now if stars were hundred dollar bills then George would be my bestest friend.

Well Done is better than well said
- Ben Franklin