Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212

    Unanswered: Convert Int Values into words..??

    Hi,

    I'm doing an online invoice system with ASP and MS SQL.

    So you got the price and total amount.

    And let say the amount is $4000.00 , there is also a portion where the invoice needs to mention it in words, "Fourty Thousand"

    Can it be "cast" ? "conver" ? or anything?
    Or is there any workaround????
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    $4000.00 = "Fourty Thousand"

    I better should be careful while doing any transactions with you .

    Maybe a function can be written to get it done ... will try it out ...

    Highly unlikely you will get a readymade function for the same ...
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212
    Opps..sorry...I was kindy sleepy..

    thanks...I'll be trying out some code too....so many numbers condition to check in the if then else.....
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    don't write your own, there are so many scripts out there already, i'm sure you can adapt the logic, even if they aren't all written in wahtever language you plan to use...

    http://developer.asna.com/Articles/b000106.asp
    http://www.idinews.com/sourcecode/IntegerFunction.html
    http://www.mvps.org/access/modules/mdl0001.htm
    http://www.vbce.com/code/functions/c...ords/index.asp
    http://www.vbexplorer.com/VBExplorer/tips/src36.asp

    how did i find these so quickly?

    google
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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