SQLTeam.com | Weblogs | Forums

Number function


Are there any function on sql server to change number into word? for example
100 will change into "one hundred"
120.55 will change into " one hundred twenty point fifty five "
so on..



No there isn't. You will have to create your own function or procedure to do that. Here's an example


thanks a lot