Re: Sorting

You can either alias the column: SELECT month(date_of_birth) birth_month ... ORDER BY birth_month or refer to the column by its number SELECT month(date_of_birth) ... ORDER BY 1 (assumes month(date_of_birth) is the first thing you select) Joseph Arcieri wrote: > > Hi, I'm having a bit of trouble... I have a simple report that lists > employees birthdays. The report uses .. "where month(date_of_birth)=month" > > How can I sort this report by month (or can't it be done?) I have the > Informix manuals and some 3rd party books but can't seem to get it!! I > thought it would be (or would like it to be) something simple as > ...order by month(date_of_birth) //////////////// ======================================================= ////////// // Dennis J. Pimple Informix Software, Inc. ////// / /// Principal Consultant 5299 DTC Blvd Suite 740 ///// // //// dennisp@informix.com Englewood CO 80111 //// // ///// /// // ////// recept: 303-850-0210 // // /////// direct: 303-740-5611 Opinions expressed are mine, / /////////// fax: 303-843-6408 and do not necessarily //////////////// http://www.informix.com reflect those of my employer