need every first character are upper in query

[mfa786]

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

[mirza_rehan]

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

[sateesh]

I think INITCAP function(which is supplied by ORACLE) is the best way that U can proceed with

Ex:Select Initcap('sateesh') from dual; will giv the Result as follows

Result :Sateesh

Satti