Hi master
Sir I use amount to word function which give me following result
four thousand five hundred sixty-three Rupees only.
But my user need following result
Four Fhousand Five hundred Sixty-Three Rupees only.
Means every first character are upper not small
Please give me idea
Than
aamir
need every first character are upper in query
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
Aamir there are 2 ways for this, if you are using PL/Sql function then user initcap function. For example your function name is <b>SpellNumber</b>
<b>Initcap(SpellNumber(1251));</b>
If you are using this way
<b>select to_Char(To_Date(Sal,'j'),'Jsp') splSal from emp</b>
Then you you set date formate <b>Jsp</b> instead of <b>JSP</b>
Hope it will solve yours problem
take care
Allah Hafiz
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
<b>Initcap(SpellNumber(1251));</b>
If you are using this way
<b>select to_Char(To_Date(Sal,'j'),'Jsp') splSal from emp</b>
Then you you set date formate <b>Jsp</b> instead of <b>JSP</b>
Hope it will solve yours problem
take care
Allah Hafiz
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
Who is online
Users browsing this forum: No registered users and 0 guests