title: Replacing a column using a SQL CASE statement
body: <p>Here is my query:</p>
  
  <pre><code>select CASE WHEN ATTRIBUTE_SOURCE is NULL THEN &lt;do calculation&gt;
              ELSE ATTRIBUTE_SOURCE END AS ATTRIBUTE_SOURCE,
              * 
  from (&lt;a table containing an ATTRIBUTE_SOURCE column&gt;)
  </code></pre>
  
  <p>The calculation is working fine, the problem is the resulting table has two <code>ATTRIBUTE_SOURCE</code> columns, one from the original table and another that is added by the CASE statement. Is there a way to <em>replace</em> the <code>ATTRIBUTE_SOURCE</code> column in the original table entirely with the <code>ATTRIBUTE_SOURCE</code> column that's generated by my CASE statement?</p>