Re: Sorting

> 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) Ok, it's pretty simple: SELECT month(date_of_birth) mth, * FROM table ORDER BY 1, other stuff... HTH. -- Cheers, Billy ----------------------------------------------------------- e-ddress: billy.wheeler@pixie.co.za Work: +27 11 803 2151 Fax: +27 11 803 2189 Cell: +27 83 250 2324 GCM/CS d++(--) h--- s+:++ !g p?+ au++ a? w+ v++/* C+++ 3 k- UCLAVH++++ p+++ L++ E-- N++ W--- M" V-- -po+ y+ t+ !5 j++ R+ G? tv+ b+++ D+ B-- e+ u** h----(++) f+ r+++ !n z++++/** -----------------------------------------------------------