View Single Post
 
Old August 18th, 2008, 08:03 PM
Jeff Moden Jeff Moden is offline
Friend of Wrox
Points: 1,536, Level: 15
Points: 1,536, Level: 15 Points: 1,536, Level: 15 Points: 1,536, Level: 15
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2006
Location: , MI, USA.
Posts: 475
Thanks: 0
Thanked 9 Times in 9 Posts
Default

Replace 'JUL' with the part of your query that returns the 3 letter month name...

 SELECT DATEPART(mm,CAST('JUL'+ ' 1900' AS DATETIME))

--Jeff Moden