title: How do I switch column values from 0 to 1 and vice versa using the update statement?
body: <p>I have a table <code>Table1</code> as follows </p>
  
  <pre><code>col1 col2
  ---- ----
   A    1
   B    1
   C    1
   D    0
   E    0
   F    0
  </code></pre>
  
  <p>I  want the result table should be as follows (by using <code>Update</code> statement)</p>
  
  <pre><code>col1 col2
  ---- ----
   A    0
   B    0
   C    0
   D    1
   E    1
   F    1
  </code></pre>