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