I want to convert numeric value 5000 to words like ‘Five thousand Rupees only’ please tell me the syntax using SQL.
2006-09-11 17:19:14 · 3 answers · asked by Zahid 1 in Computers & Internet ➔ Programming & Design
You can use the following SQL Statement under ORACLE environment:-
select to_char ( to_date ( 5000, 'J' ), 'JSP' ) from dual
Oracle supports upto - 5373484.
Donot know whether it is supported by others.
2006-09-11 18:27:58 · answer #1 · answered by mashiur1973 2 · 0⤊ 0⤋
Try the SQL statement below:
select to_char ( to_date ( 5000, 'J' ), 'JSP' ) || ' Rupees Only' from dual
KaBalweg
http://smartcoder.awardspace.com
2006-09-11 20:04:44 · answer #2 · answered by dabsani 3 · 0⤊ 0⤋
I don't think that is possible with SQL. You need to develop a program to do that.
2006-09-11 17:33:29 · answer #3 · answered by Jayaprakash V 2 · 0⤊ 0⤋