Need to change case SMITH, JOE to Smith, Joe

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 - 17:58:44 CST