>

>mymonth = 'APR' (or any)
>WAIT WINDOW CHRtran(mymonth,'JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC','01,02,03,04,05,06,07,08,09,10,11,12')
>

>
>the above code obviously does not work. What does? thanks, Randy

If you need to do this a lot, I suggest creating a cursor or table to hold the data and using a look-up.

Tamar