title: Null and Empty record with query
body: <p>I have question regarding NULL and '' (Empty) data.
  Below is the query</p>
  
  <pre><code>with tempCTS
  as(
  select null as [blank] ) 
  select * from tempCTS t
  </code></pre>
  
  <p>Output is NULL</p>
  
  <p>Another Query with Empty Check </p>
  
  <pre><code>with tempCTS
  as(
  select null as [blank] ) 
  select * from tempCTS t where  t.blank &lt;&gt; ''
  </code></pre>
  
  <p>Ouput is nothing </p>
  
  <p>My question is why the null records are not fetching once the black checked is placed</p>
  
  <p>PS:- I need null and data records but not the one having empty string</p>
  
  <p>Thanks in Advance.</p>