>I have set a character field named Month with a regular index to store name of the months.When I use SET ORDER TO MONTH it indexes the field Month alphabetically as it is supposed to.How can I make it index on January , Feburary , March and so on instead of April, August, December etc....
>Thank You All
>Zaraq Bari

You could add another (numeric) field to hold their order and index on that:

- Month -|Num
January -| 1
February | 2
March ---| 3
...