update 4 columns and over 5000 records

[raniweb]

Hello,
I am trying to figure out how to update values of four columns and over 5000 rows. I'm thinking that I need to run something similar to

UPDATE TBLname
SET column_name1 = Null,
column_name2 = Null,
column_name3 = Null,
column_name4 = Null

Am I on the right path or am I missing something? Thank you in advance for your help!

 

[jbenson001]

That is the correct syntax for an Update.

 

[raniweb]

Thank you for the confirmation of that. It's always nice to be able to double check. Thanks again!

 

[jbenson001]

Hey not a problem..
Jim