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.