>Dear Experts
>
>Table1 has following THREE fields as
>
>nmonth n(2)
>nyear n(4)
>cmonth c(8)
>
>and data is as
>
>nmonth---nyear----cmonth
>--8------2006-----
>--11-----2007-----
>--5------2006-----
>
>I want to fill column3 as
>Aug-2006
>Nov-2007
>May-2006
>
>
>Please help

replace all cMonth with left(cMonth(date(nYear, nMonth, 1)),3) + '-' + padl(nYear,4)

Cetin