Rs in word - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Rs in word

Author

Topic

krushnapanda
Starting Member

18 Posts

Posted - 2007-09-03 : 06:18:54

Hello dear,
How to convert digit to word by using a function/sp
Example
Rs. 258 convert to Two Hundread Fifty Eight Only
Rs 250000 convert to Two Lakh Fifty Thounsand only

Thanks

Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-03 : 06:25:30

Have you searched SQLTeam, or are you just fetching for the quickest answer?

E 12°55'05.25"
N 56°04'39.16"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-03 : 06:26:46

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=86067&SearchTerms=two,hundred,fifty

E 12°55'05.25"
N 56°04'39.16"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-09-03 : 07:06:40

If you want to show data in reporting tools like Crystal Reports, make use of ToWords function

Madhivanan

Failing to plan is Planning to fail

krushnapanda
Starting Member

18 Posts

Posted - 2007-09-03 : 07:08:10

Hi, I was searched but when i am putting 250000 it give like this type of result
TWO HUNDRED FIFTY THOUSAND, but i want this type of result
TWO LAKH FIFTY THOUSAND,
so for fetching quickest answer i post my query.
Thank You

Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-03 : 08:05:20

I "think" you have to alter the function to fill YOUR needs.

E 12°55'05.25"
N 56°04'39.16"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-09-03 : 08:09:28

quote:
Originally posted by krushnapanda

Hi, I was searched but when i am putting 250000 it give like this type of result
TWO HUNDRED FIFTY THOUSAND, but i want this type of result
TWO LAKH FIFTY THOUSAND,
so for fetching quickest answer i post my query.
Thank You

Thanks

Yes You need to modify the function to have Indian way of formation

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources