Post reply

How to Convert Numbers (money) into Words in Indian Format

  • September 25, 2009 at 10:03 pm

    #214860

    Hi

    I want to convert indian rupees which is in numeric into words.For example:let we have 1234567.50 rupees.It will display like as "twelve lakhs thirty four thousand five hundred sixty seven rupees fifty paise".

    Thanks

  • September 26, 2009 at 2:29 pm

    #1058778

    raaz66

    Read this post -- admittedly it does not change into Indian currency, but believe you can modify the posted code easily to obtain what you need

    http://www.sqlservercentral.com/Forums/FindPost794177.aspx

    It will take a while to open the post due to the amount of code posted.

    Let me state once again that using T-SQL for this type of task is NOT what T-SQL was designed to do. It would be faster and easier for you to do the conversion in your front end. That said hope this assists you

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply