>Zaraq,
>
>How about:
>
>INDEX ON ;
>IIF(MONTH = "JAN",1,;
>IIF(MONTH ="FEB",2,;
>IIF(MONTH="MAR",3,;
>IIF(MONTH="APR",4,;
>IIF(MONTH="MAY",5,;
>IIF(MONTH="JUN",6,;
>IIF(MONTH="JUL",7,;
>IIF(MONTH="AUG",8,;
>IIF(MONTH="SEP",9,;
>IIF(MONTH="OCT",10,;
>IIF(MONTH="NOV",11,;
>IIF(MONTH="DEC",12,0)))))))))))) TAG WHATEVER
>
>HTH
If we're going to use dirty tricks 'round here, how about
index on atc(LEFT(month,3), "JAN FEB MAR APR AUG MAY JUN JUL AUG SEP OCT NOV DEC") tag whatever
It won't give the exact numbers, but it will put them in sequence, and should be somewhat faster.