Custom Sort [message #402748] |
Tue, 12 May 2009 05:33  |
freakabhi
Messages: 74 Registered: November 2007 Location: mumbai
|
Member |
|
|
Hi All,
Is there any way to define Custom Sort order in the SQL, like when u sort minthname , it will give April, august......
but I want like Januart, February............
Please suggest me some ideas, if somebody has any of it..
thanks,
freakabhi
|
|
|
|
|
Re: Custom Sort [message #402782 is a reply to message #402748] |
Tue, 12 May 2009 07:59  |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
You can order by any function that you like.
All you need is a function that maps your data onto a set of numeric or character values that are ordered how you want them.
|
|
|