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

From: <jerschio_at_my-dejanews.com>
Date: Thu, 04 Feb 1999 13:14:56 GMT
Message-ID: <79c6ga$ek5$1@nnrp1.dejanews.com>

> > 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.

select initcap('PETER VON HAUSEN')from dual; will give you Peter Von Hausen is there any way to make oracle understand that the von part should not be in uppercase.

If you can answer this question please send a cc to jeroen.schiott_at_merkantildata.no

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 04 1999 - 07:14:56 CST