Hi, Anyone know how to convert number to word in Transact SQL ? eg 1268 to One Thousand Two Hundred Sixty Eight ?? Thank You !
I think, you need to write some T-SQL program for it.Can have a quick look at this logic.. http://www.ozgrid.com/VBA/CurrencyToWords.htm
[quote user="yhchan2005"]Hi, Anyone know how to convert number to word in Transact SQL ? eg 1268 to One Thousand Two Hundred Sixty Eight ?? Thank You ![/quote] See if this helps: http://www.sqlservercentral.com/Forums/Topic15272-23-1.aspx
[quote user="FrankKalis"] [quote user="yhchan2005"]Hi, Anyone know how to convert number to word in Transact SQL ? eg 1268 to One Thousand Two Hundred Sixty Eight ?? Thank You ![/quote] See if this helps: http://www.sqlservercentral.com/Forums/Topic15272-23-1.aspx [/quote] I am getting the errorServer Error in '/' Application. The resource cannot be found. Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly. Requested URL: /Community/forums/t/24058.aspx
[quote user="Madhivanan"] [quote user="FrankKalis"] [quote user="yhchan2005"]Hi, Anyone know how to convert number to word in Transact SQL ? eg 1268 to One Thousand Two Hundred Sixty Eight ?? Thank You ![/quote] See if this helps: http://www.sqlservercentral.com/Forums/Topic15272-23-1.aspx [/quote] I am getting the errorServer Error in '/' Application. The resource cannot be found. Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly. Requested URL: /Community/forums/t/24058.aspx [/quote] I just remembered that I posted that on SSC a while ago and went this morning to search that thread. So, the URL being valid, they must have had some troubles with their forum app today.