I have a database where the month is kept in a separate column. The column is populated with numbers 1 to 12

Is there a function in Webfocus that can convert 12 to December?

This message has been edited. Last edited by: FP Mod Chuck,

Other then DECODE?

Or a compute/define...something in here may help:

http://forums.informationbuild...061072742#4061072742

Something like this perhaps.

DEFINE FILE CAR
 MNTH/Mt = SEATS
END

TABLE FILE CAR
SUM MNTH
BY SEATS
END

Or a slight variation......

DEFINE FILE CAR
MNTH/Mtr = SEATS
END

TABLE FILE CAR
SUM MNTH
BY SEATS
END

You can use FPRINT to convert to an ALPHA field ...

DEFINE FILE CAR
MNTH/Mtr = SEATS;
MNTH1/A03 = FPRINT(SEATS,'Mt',MNTH1);
MNTH2/A09 = FPRINT(SEATS,'Mtr',MNTH2);
END

TABLE FILE CAR
SUM MNTH MNTH1 MNTH2
BY SEATS
END