How we can Show integer value into Words.

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

How we can Show integer value into Words,

Eg. When we buy some product at e-commerce shop or Malls we get receipt for our payment.
if the product cost is Rs 100 then on receipt Amount is given in Integer - Rs 100 &
and also Amount in words - Rupees One hundred Only.

how Amount in Words is calculated from Integer to Words ?
sometimes even decimal also come in amount.

how to achieve this

Amount | Words
Rs 100 | One Hundred
Rs 250.45| Two Hundred Fifty and Forty Five Paise

Posted 19-Nov-14 21:49pm

Tarun Jaiswal

Add a Solution

Comments

BillWoodruff 20-Nov-14 9:41am

I'd like to help you with this in a way where you learn the most on your own: how far are you along with this; what have you tried ? Can you post some code ? Is this homework, or are you doing this "for yourself" ?

How "high" a Rupee value do you wish this translator to work with: include 'Arab and 'Kharab ?

Tarun Jaiswal 21-Nov-14 1:11am

this is not a Home Work, it is a curiosity to learn how this action is performed is there any in-built classes or every developer have to implement his own logic to achieve this Task.
& I currently did not understand how the value is calculated becaused i read some Articles on Internet there they say to create table with all numerical digit, some say go on dividing numbers with total digit count. I dont have a proper Logic how to calculate it.
Currently my required value upto Lakh only.
Thanks for your reply

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Shweta N Mishra · Accepted Answer · 2014-11-19T21:55:00

Solution 1

you would have to create table to store the definition of each number and i.e.

Number and the word mapped to it.

e.g. 11="ELEVEN"

Refer below.

sql-server-query-to-convert-numbers[^]

Posted 19-Nov-14 21:55pm

Shweta N Mishra