Update 1 colum with other column in same table

• Dee Dee-422077

  Ten Centuries

  Points: 1082

  More actions

  July 15, 2016 at 12:15 pm

  #311827

  Hi-

  Table TEST

  id width Lengh

  1 0.0 20.0

  2 2.3 1.00

  3 0.0 23.0

  4 1.9 11.0

  I would like to update field "Width" with data in "Length" when Width = 0 and Lengh >0

  then I also want to reset the lengh to blank after that, can you please advise how to do this.

  What I have so far is

  UPDATE TEST

  SET width = lengh

  SET lengh = '' ----Is is okay to do this?

  where width = 0 and length > 0

  Thanks.

  Dee

• FridayNightGiant

  SSCertifiable

  Points: 7151

  More actions

  July 15, 2016 at 12:18 pm

  #1890403

  You use a comma to separate the columns in a set. Assuming the length field is numeric you will have to set it to 0 or null depending on the column properties

  UPDATE TEST

  SET width = length

  ,length = 0

  where width = 0 and length > 0