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