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
 General SQL Server Forums
 New to SQL Server Programming
 spell to split

Author  Topic 

rajnidas
Yak Posting Veteran

97 Posts

Posted - 2013-10-23 : 04:49:35
hi every one

we want split words figure using with spell number



SELECT DBO.fn_spellNumber A)....('22,33,44,555.29','L',1,1)
B... -('22,33,44,555.29','L',1,1)

example : result would be 1 :Twenty Two Crore Thirty Three Lakh Fourty Four Thousand
result would be 2 :And Fifty Five Twenty Nine Cents


any one , kindly help

thanks

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-10-23 : 05:31:54
Refer
http://www.novicksoftware.com/udfofweek/Vol2/T-SQL-UDF-Vol-2-Num-9-udf_Num_ToWords.htm
http://www.sqlservercentral.com/Forums/Topic794134-149-1.aspx
http://www.sqlservercentral.com/scripts/function/65640/

--
Chandu
Go to Top of Page
   

- Advertisement -