Convert number to words

Question

Post reply

Convert number to words

vikramchander90

Ten Centuries

Points: 1093
More actions
February 12, 2014 at 6:51 am

#288133

Hi,
Is it possible to write a function to convert a numbers to words based on language?
I have amount, currency and language as input.
For example if input is 100000 and language is english then should get one lakh
if input is 100000 and language is english united states then should get 100 thousand
similarly for other languages

Viewing 5 posts - 1 through 4 (of 4 total)

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

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 1

Is it possible to write a function to convert a numbers to words based on language?
...

Yes, it is possible. However, you will make your life easier if you Google it first...

It may safe you some typing!

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

vikramchander90 Ten Centuries Points: 1093 More actions · Answer 2

I am unable to find in google hence posted here. Can you please suggest how it can be done.

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 3

I wonder what have you tried to search for?

Google search returns a banch of topics. One is here leading to sample:

http://stackoverflow.com/questions/1673265/how-to-write-number-to-word-function-in-sql-server

I'm sure you will also find something searching SQLServerCentral itself.

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

Lowell SSC Guru Points: 323518 More actions · Answer 4

also be careful; I know this is a common homework question in some SQL classes in India, and you don't want to grab someone elses solution.

you want to learn through the class, build on the concepts they are trying to teach, and not get in trouble. you bet they've already got the same solutions we point you to.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!