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

Hi,
Would the INITCAP('UPPER et lower') giving Upper Et Lower do the trick. Guy.

"Dalgarno, Garry" wrote:

> 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 - 19:31:31 CST