开发者

Convert number to words in db2

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜