-
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,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|