>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

There is no function that will take the name of a month and return the month number as CMONTH() will do for a date. There are two, as I see it, choices.

Either build the table so that the record number corresponds to the number of the month, or create a dummy date field to index on using the MONTH() function. If the latter is chosen, simply fill it with any date for the desired month.

hth,