Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Need to change case SMITH, JOE to Smith, Joe

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

From: Guy Quesnel <gquesnel_at_magma.ca>
Date: Fri, 15 Jan 1999 01:31:31 GMT
Message-ID: <369E8C98.48EC819@magma.ca>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US