Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL query for retrieving numeric value and printing as words

Tags:

sql

What will be the query for retrieving a number from a column of a table and printing it in words? e.g:-data is 72 it should be printed as Seventy Two

like image 414
krishna Avatar asked Feb 24 '26 23:02

krishna


1 Answers

No RDBMS I know of has such a function, and even though you could write one as a udf or sproc most DBs have abyssal string handling. Do this in your client app.

like image 96
Donnie Avatar answered Feb 26 '26 13:02

Donnie



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!