This content has been marked as final. Show 1 reply
I need some help in reporting. I have a report that has some number & currency fields. The customer wants those numbers written out in words.
For e.g. $1000 - $ One Thousand
or 999 - Nine Hundred Ninety nine
Using CAST it only convert the number to string not actual words.
Is there any way to write it out in words in reports?
Thanks in advance
CAST only changes the data type e.g. Integer to String as you rightly pointed out, there are no out of the box functions that would allow you convert them to the format you require.