SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Guru johnjohn2's Avatar
    Join Date
    Apr 2004
    Location
    here
    Posts
    746
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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?

  2. #2
    chown linux:users\ /world Hartmann's Avatar
    Join Date
    Aug 2000
    Location
    Houston, TX, USA
    Posts
    6,455
    Mentioned
    11 Post(s)
    Tagged
    0 Thread(s)
    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.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •