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


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.
 

>Thanks for any help.

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.
Received on Thu May 02 1996 - 00:00:00 CEST

Original text of this message