Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Convert Mixed case data to Upper/Lower case
You are wondering if there is a switch you throw which presents upper or
lower case. There is not. You would have to update the data in the NAME
column to upper or lower case. Assuming you have enough rollback space,
you could update table, set name=upper(name);
sanjay.raj_at_roche.com wrote:
: I have a table with 2 million rows and the names in NAME column are entered
: in Mixed case.I don't want the users to use UPPER/LOWER in their queries and
: hence would like to change the data to all upper/lower case. What is the best
: way to do this?
: Thanks
: -----------== Posted via Deja News, The Discussion Network ==----------
: http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
-- Received on Thu Nov 12 1998 - 15:59:46 CST