title: Average and case in SQL Server 2012
body: <p>I'd like to have the average of a column when its bigger than zero. </p>
  
  <pre><code>Select Avg(Case when Column &gt; 0 then Column else 0 end) as Avg
  </code></pre>
  
  <p>but I'm afraid the <code>else</code> clause is not correct. I want to ignore the zero values in the average. </p>