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'
精彩评论