Sorry this is for the Day of Month Try the same function with the month DATEPART(mm, Birthdate) AS MonthofBirth
Then ORDER BY MonthofBirth Hope this help On 7/12/07, Mike Hughes <[EMAIL PROTECTED]> wrote: > Try > In Selectstaement add > DATEPART(dd, Birthdate) AS DayOfBirth"; > > OrderByStatement = "ORDER BY DayOfBirth" > > > On 7/12/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > I have a table with the month stored as January, February, > > March.....etc. How do I write a query to order by month so that January > > is first, Feb second and so on? I'm using SQL server and ColdFusion. > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2867 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
