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