bulk updates

Hi

I need to update a column from upper case to lower case for every single row without changing their values, how do I do that?

cheers

[Edited by Sweetie on 02-26-2001 at 07:29 AM]

Try
update table_name
set column_name = lower(column_name);

HTH

David.

Hi,

update table_name set column_name = lower(column_name)


cheers

chris.

Hi..

If you don't want to keep old values then you can update as

update table_name set column_name = lower(column_name)

If you want to keep old values also then you have to keep into separate table... or create a view of lower values


insert into new_table_name select lower(column_name) from old_table_name

or

create view new_table_name as select lower(column_name) from old_table_name

Any confusion then mail me at nkakrani@yahoo.com

Naresh

Hi,

Use

update table_name set column_name = lower(column_name)

Rgds,