(anonymous) wrote:
> [...]
> I intend pass the number of the month(say 1 for January , 2 for February
> etc>) as the parameter to this method and return a number that corresponds
> to the index of the month in the new order , say I pass 8 for August , I
> return 11 , in order to get the index of August in he financial year
> calendar somewhat like this
> [...]
You don't need any function for that, just use "ORDER BY
Month < 4, Month".
Tim