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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-12-08 : 09:03:19
|
| Kokila writes "Is there any function which is used to convert numbers to words in mssql sever 2000 EG:1200 as Thousand Two Hundred" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-08 : 09:13:33
|
| No, there is no built-in function.But there are plenty of user-defined functions out there...just google them.Also, don't do these kind of things at Back-end, do it in the presentation layer. SQL server is not the best when it comes to string manipulation.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
convert numbers to words