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 [email protected]

Naresh