Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |