hello, is there any way so that months r ordered as that of calender year.
means . i have a month field of 3 chars. like Jan, Feb, Mar etc when i select distinct months , the result will be displayed in the calender year month order. but if i use order by mon then this order jan,feb,mar will go and it will order accorg to the first char of the month name. but i want to arrnage in calender month order even when i count the stocks for each month with group by statement. is there any option to sort with 2nd and 3rd char also like that of sql in mysql ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]