SQLTeam.com | Weblogs | Forums

Number function


#1

Hi,
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..

thx


#2

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


#3

thanks a lot