title: How do I check if a Sql server string is null or empty
body: <p>I want to check for data, but ignore it if it's null or empty. Currently the query is as follows...</p>
  
  <pre><code>Select              
  Coalesce(listing.OfferText, company.OfferText, '') As Offer_Text,         
  from tbl_directorylisting listing  
   Inner Join tbl_companymaster company            
    On listing.company_id= company.company_id      
  </code></pre>
  
  <p>But I want to get <code>company.OfferTex</code>t if <code>listing.Offertext</code> is an empty string, as well as if it's null.</p>
  
  <p>What's the best performing solution?</p>