Is there any function to convert number to word

[longfellow]

hai all

I have a number returned from the database using the Count function. For eg it returns 12 followed by some text string like males.
Is there any way i can display the above output as twelve instead of 12 or any other count returned for that field .
This will help me in having a neat format throughout my report as i use the count function at lot of places

Thanking you

Longfellow

 

[LMCRYER]

not sure about this but try the towords(field)

LMC cryerlisa@hotmail.com

select * from Management where proj_mgmt_skills <> NULL

0 records returned

 

[Trainingjason]

The following will work

towords({field}) will give you a response of twelve 00
towords({field},0) not decimal places

Regards



trainingjason