Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Convert Mixed case data to Upper/Lower case
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 - 10:55:20 CST