Converting Date

[luvtitans50]

I am trying to get a format of mmddyyyy with this formula:

Convert(VarChar(2), month(startdate)) + CONVERT(VarChar(2),Day(startdate)) + Convert(VarChar(4), year(startdate)) as startdate

However it comes out mddyyyy when the month is a single digit, how can I accomplish a 2digit month at all times?

Thanks!!

 

[gmmastros]

Replace(Convert(varchar(10), startdate, 101), '/','')

-George

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

 

[luvtitans50]

Awesome!!! Thanks :0)....