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

Neither replace or translate. Simply use initcap.

e.g.
Table: clients
Column: client_name varchar2(30)

update clients
set client_name = initcap(client_name);

That's all there is to it.

Dalgarno, Garry wrote in message <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 - 22:24:20 CST