title: Getting zero instead of Blank value
body: <p>Why below code gives me 0 or zero instead of blank value or blank row
  in column ValueA.</p>
  
  <p>How can I change it to blank value?</p>
  
  <pre><code>select ValueA = case when ValueB = 'No' then ValueA
                       when ValueB = 'Yes' then ''
                       else ''
                       end
  From Table
  </code></pre>
  
  <p>or </p>
  
  <p>if I use <code>ValueB = 'Yes' then CAST(NULL AS varchar(25))</code>  gives me Null 
  and I want blank where it is Null, but when I try to convert to blank
  I get zero.  Why?</p>
  
  <p>How can I get blank? </p>