title: SQL statement / stored procedure to replace NULL values in single table
body: <p>Very new to SQL and I've been presented with the following problem. I apologize if it's a simple fix. All the replacement questions I've looked at this morning didn't seem to solve this exact problem.  </p>
  
  <p>I'm using SQL Server 2017 and I have a table similar to the following, the actual table is 100k+ rows but follows this format, it just has more individual items and columns:</p>
  
  <pre><code>ColA    ColB    ColC    ColD    ColE    ColF
  ----    ----    ----    ----    ----    ----
  ROW1    Item1   2341    Null    Null    Null
  ROW2    Item2   7953    Null    Null    Null
  ROW3    Item1   Null    2342    Null    Null
  ROW4    Item2   Null    9827    Null    Null
  ROW5    Item1   Null    Null    1945    Null
  ROW6    Item2   Null    Null    0745    Null
  ROW7    Item1   Null    Null    Null    1298
  ROW8    Item2   Null    Null    Null    2356
  </code></pre>
  
  <p>Is there a way to programmatically update the table so that ROW1 and ROW2 would have all the non NULL values for columns D, E, and F?</p>