Ok, convert character, add a leading zero, take the rightmost two characters.
Ray Thompson Systems Administrator Tau Beta Pi Association www.tbp.org The Engineering Honor Society Integrity and Excellence in Engineering > -----Original Message----- > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > Sent: Friday, September 12, 2003 12:18 PM > To: CF-Talk > Subject: Re: grouping a query on date > > > >>ORDER BY year(moment) & '/' & month(moment) & '/' & day(moment) > > Thanks, but the '/' does not change anything in the sort. > The problem is that I need the month and days as '09', not '9' > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
