numbers to words
I'm using postgresl 7.4.
Is there any way to create a sql statement that would convert the numeric value in to english words? For example I want to create a report for printing checks. If I have a field with numeric values stored in it such as $123.23, I'd like to create another field in the query that would say "one hundred, twenty three dollars and twenty-three cents. Is this possible?
You may want to look at the PEAR library for this. http://pear.php.net/package-info.php...=Numbers_Words is a package that allows you to do exactly what you want.