>can any body please help me
>i have a caracter field like such 990501
>and i allready changed it with the substring and left comand to 05-01-99, what i ned to do then is convert the o5 to May or month in numbers to the first three leters of the month. Hoy would i go about this..>
Dovi,
Look at the CMONTH() and MONTH() functions. After you've coverted the string to a date these will provide you the information you need.
George
Ubi caritas et amor, deus ibi est