Home » SQL & PL/SQL » SQL & PL/SQL » firstname and middel name in capitals?
firstname and middel name in capitals? [message #265038] Wed, 05 September 2007 05:25 Go to next message
tondapi
Messages: 99
Registered: August 2007
Location: usa
Member
Hi

in my database firstname and middelname are there
firstname middelname
smith jk

i user want to see like
firstname middelname
Smith Jk
How and which function is used?
Re: firstname and middel name in capitals? [message #265040 is a reply to message #265038] Wed, 05 September 2007 05:27 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
Use initcap function
Re: firstname and middel name in capitals? [message #265059 is a reply to message #265038] Wed, 05 September 2007 06:02 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
INITCAP
Regards
Michel
Previous Topic: Resolving dead lock error
Next Topic: constraints
Goto Forum:
  


Current Time: Sat Dec 03 12:25:09 CST 2016

Total time taken to generate the page: 0.21325 seconds