开发者

Convert number to words in db2

开发者 https://www.devze.com 2023-04-05 07:19 出处:网络
I am using db2. I have a table which gives a value. For ex : value=5000 Is there any way in query or something where i can convert the number into a word.

I am using db2. I have a table which gives a value. For ex : value=5000

Is there any way in query or something where i can convert the number into a word.

I above exampl开发者_如何学编程e "Five thousand".....

I am using db2.


I think this is not the job which database should do. So the answer is no.


You could use SELECT CASE, e,g.

SELECT CASE WHEN (YOURFIELD = 5000) THEN 'Five Thousand' ELSE 'Something Else'
0

精彩评论

暂无评论...
验证码 换一张
取 消