Updating multiple collumns with replace function

• Mark Green-451799

  SSC-Addicted

  Points: 490

  More actions

  April 8, 2008 at 9:31 am

  #205242

  I feel that I want to write a script like:

  UPDATE mr_temp_text_file_B SET (PRIMARY_DIAGNOSIS_CODE, SECONDARY_DIAGNOSIS_CODE_1, SECONDARY_DIAGNOSIS_CODE_2, SECONDARY_DIAGNOSIS_CODE_3) IS NULL WHERE LIKE 'NULL'

  There are about 30 columns. Do I have to write a new line for each column?

• Kent Waldrop

  Hall of Fame

  Points: 3064

  More actions

  April 8, 2008 at 11:02 am

  #799905

  Mark:

  I would suggest that you start by giving a look at the UPDATE article in books online.