Need to Insert Leading 0 to Current Month

[JohnBates]

hi experts,

If I use the month function, it returns a single digit (for months 1 thru 9).

I need to get it to a 2 digit value.
If I have : curMonth = month() I get a value of 1

How can I insert a leading zero to get a value of '01' ?

Pretty simple stuff but I'm stumped.
Thanks, John

 

[dbomrrsm]

select right('00'+cast(1as varchar),2)

[blue]DBomrrsm[/blue]

 

[jshinall]

This would also work.

Select convert(varchar(2), GetDate(), 101)

 

[JohnBates]

I messed up - should have posted this question in the VBscript forum.

My apologies for wasting your time.
John

 

[dbomrrsm]

its ok I probably would have wasted it myself anyway !

[blue]DBomrrsm[/blue]