Home » SQL & PL/SQL » SQL & PL/SQL » sql question re: UPPERCASE
sql question re: UPPERCASE [message #8022] Tue, 22 July 2003 09:20 Go to next message
ben lepwhitch
Messages: 1
Registered: July 2003
Junior Member
I'm looking to return names with just the first letter capatilized. Can someone show me what the statement would look like?
Re: sql question re: UPPERCASE [message #8023 is a reply to message #8022] Tue, 22 July 2003 09:49 Go to previous messageGo to next message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
quote from ben lepwhitch:
----------------------------------------------------------------------
I'm looking to return names with just the first letter capatilized. Can someone show me what the statement would look like? 

----------------------------------------------------------------------
SQL> SELECT e.ename
  2  ,      <a href="http://www.engin.umich.edu/caen/wls/software/oracle/server.901/a90125/functions52.htm">INITCAP</a>(e.ename) capitalized
  3  FROM   emp              e
  4  /
  
ENAME      CAPITALIZE
---------- ----------
SMITH      Smith
ALLEN      Allen
WARD       Ward
JONES      Jones
MARTIN     Martin
BLAKE      Blake
CLARK      Clark
SCOTT      Scott
KING       King
TURNER     Turner
ADAMS      Adams
JAMES      James
FORD       Ford
MILLER     Miller
  
14 rows selected.
  
SQL> 
HTH,

A.
Re: sql question re: UPPERCASE [message #8024 is a reply to message #8022] Tue, 22 July 2003 10:35 Go to previous messageGo to next message
Ali
Messages: 88
Registered: March 2000
Member
select initcap(ename) from emp;
Re: sql question re: UPPERCASE [message #8040 is a reply to message #8022] Tue, 22 July 2003 22:03 Go to previous message
Pawan
Messages: 33
Registered: June 2002
Member
Hi There...

Use Initcap() function with the column name
Previous Topic: A query - Please help
Next Topic: sysdate usage
Goto Forum:
  


Current Time: Thu Mar 28 09:04:19 CDT 2024