Re: IMAGINE: USERS HAVE CHANGED THEIR MINDS
From: Harri Kaukovuo <hkaukovu_at_us.oracle.com>
Date: 1996/05/02
Message-ID: <4mb8vd$4il_at_inet-nntp-gw-1.us.oracle.com>#1/1
This Is Street Name 142
Date: 1996/05/02
Message-ID: <4mb8vd$4il_at_inet-nntp-gw-1.us.oracle.com>#1/1
magc_at_vms.cis.pitt.edu wrote:
>One year after conversion, and the users have changed their minds . . .
>Our users are no longer satisfied with storing text (names, streets, etc)
>in upper case; they want to store their text in mixed-case.
>Please offer suggestions for converting the text strings that are stored
>in upper case to mixed-case strings. Has anyone used 3rd-party products?
>Written in-house scripts? Told the users to take a long walk off a short
>pier?
>Please respond directly to me.
You could use SQL function INITCAP() to convert uppercase letters to
mixed case.
An example:
SQL> select initcap('THIS IS STREET NAME 142') from dual;
INITCAP('THISISSTREETNA
This Is Street Name 142
- Harri hkaukovu_at_us.oracle.com ** The statements and opinions expressed here are my own and ** do not necessarily represent those of Oracle Corporation.