title: Conditional sum in SQL Server
body: <p>I have this table in MSSQL:</p>
  
  <pre><code>ID   OP1   OP2  OP3
  330   0     0    1
  331   1     0    0
  332   3     2    0
  </code></pre>
  
  <p>OP's are options. There can go from 1 to 9, 0 means that question was not answer.</p>
  
  <p>How can i "sum" in a column called "Answered", like so:</p>
  
  <pre><code>ID   OP1   OP2  OP3  T
  330   0     0    1   1
  331   1     0    0   1
  332   3     2    0   2
  </code></pre>
  
  <p>A value over 0, means answered.</p>
  
  <p>I try with CASE WHEN, IF statements.</p>