title: Select default value if column has 0 value in SQL Server
body: <p>If the column has 0 value, I need to select like 'xyz' with other select column value</p>
  
  <p>For example,</p>
  
  <pre><code> id    col1   col2
   1       0     abc
   2       2     xyz
  </code></pre>
  
  <p>I need to select all column in this table but <code>col1</code> if has 0 then need to show 'xyz'.</p>