title: Populate New Column with Existing Column Based On Criteria
body: <p>I am selecting into an existing column C from column A if it has a value greater than zero.  If not then I want to populate it with column B.  It will populate with column A only if column B is zero.  If both column A and B have values it always uses B.  Any help would be appreciated. </p>
  
  <pre><code>( 
     CASE
         WHEN column A &gt; 0  THEN column A
         ELSE column B                
     END
  )
  </code></pre>
  
  <p>My insert into was correct but my select had the columns reversed which was causing what I thought was an error.  Thanks for all of your help.  What a noob thing to do.</p>