Re: IMAGINE: USERS HAVE CHANGED THEIR MINDS

In article <31891E60.67A9_at_tapestry.com>, jason.wells_at_tapestry.com says... [snip)
>> 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 know, that's one of those things that sounds easy and really isn't... I
> mean, you could
>just make a routine that takes a string and converts all but the first lett
>er to lower case,
>but then what about all those "McWhatevers" and "Klaus von Bulows" and so o
>n? I think the

[snip]

Why not update the appropriate tables using Oracles built in function InitCap.

eg Update address_table set street = initcap(street),

                            city = initcap(city) .....;

    SET TRANSACTION USE ROLLBACK SEGMENT BIGRBS; OR use a PL/SQL Cursor to traverse through the table and commit every

   so many rows.

Babette Dale Underwood
dale_at_fox.nstn.ca                             Received on Fri May 10 1996 - 00:00:00 CEST