bulk updates
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: bulk updates

  1. #1
    Join Date
    Oct 2000
    Posts
    139
    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]

  2. #2
    Join Date
    Feb 2001
    Posts
    123
    Try
    update table_name
    set column_name = lower(column_name);

    HTH

    David.

  3. #3
    Join Date
    Jul 2000
    Posts
    37
    Hi,

    update table_name set column_name = lower(column_name)


    cheers

    chris.

  4. #4
    Join Date
    Oct 2000
    Posts
    6

    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


  5. #5
    Join Date
    Feb 2001
    Location
    Adelaide, Australia
    Posts
    159
    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
  •  



Click Here to Expand Forum to Full Width