title: Insert into a different column using case statement
body: <p>Is it possible to select on a table, then use a Case statement to populate the results into a different column?  I've seen an example of using 'Case' to query but not insert into a new column.  I've tried various combinations but coming up short.</p>
  
  <p>For example,</p>
  
  <pre><code>    Table - CLIENTDETAILS
  
      VATRATE - 1, 2, 3, 0  //This is a populated column with 6500 rows
  
      VATPERC - 15.0, 17.5, 20.0, 0.00  //This is an empty column that needs to be filled with case results.
  
      INSERT INTO CLIENTDETAILS(VATPERC) values(
      (SELECT CASE VATRATE
        WHEN '1' THEN '15.0'
        WHEN '2' THEN '17.5'
        WHEN '3' THEN '20.0'
        WHEN '0' THEN '0.00'
      END
      FROM CLIENTDETAILS AS CLIENTDETAILS_1))
  </code></pre>
  
  <p>Thanks for your help as always.</p>