Re: Need to change case SMITH, JOE to Smith, Joe

From: Joseph Sunderland <tpcjsunderland.NO_at_SPAMgci.com>
Date: 14 Jan 1999 17:37:35 -0900
Message-ID: <01be402f$feb22180$734b8ccd@mis-c6238>

Garry,

Why not use the built-in function INITCAP to do this:

SQL> select initcap('SMITH, JOE') from dual;

INITCAP('S

---

Smith, Joe

SQL> Joseph Sunderland
(remove the nospam from my email address to get the real one).

Dalgarno, Garry <gdalgarno_at_mail.canfor.ca> wrote in article <9vvn2.83$wF1.444480_at_news.bctel.net>...
> I need to change the case (Upper to Lower) in a few of my database
columns.
> But I still need the first char to remain a Uppercase.
>
> From: ALL UPPER
> to: All Mixed (leave the first char Upper in a word, and lower the rest)
>
> I need to use standard sqlplus...
> Which is better? replace or translate
> How do leave the first char Upper?
>
> Thanks,
> Garry Dalgarno
>
>
>
Received on Thu Jan 14 1999 - 20:37:35 CST