RE: REPLACE 1 WITH FIRST,2 WITH SECOND

> > The report writer to be able to transform numbers to Words as follows
> >
> >
> > PL_NO WORD
> > 1 FIRST
> > 2 SECOND
> > 3 THIRD
> > 4 FOURTH
> > 5 FIFTH
> > ETC
> >
> > I'm building a report, and I'd want the report writer for the occurence of the field 'PL_NO' to write
> > its equivalent word instead in the report.
> >
> > Pls assist
> >
> > Thanks
>
> http://fox.wikis.com/wc.dll?Wiki~DateOrdinal~VFP
>
> Mike Yearwood
>
>

A bit more generalized I believe this would do too:

PROCEDURE GetOrdinal (tiNumber)
RETURN ;
TRANSFORM(tiNumber)+;
ICASE(;
INLIST(tiNumber,11,12,13),'th', ;
tiNumber%10=1,'st',;
tiNumber%10=2,'nd',;
tiNumber%10=3,'rd',;
'th')

-Anders