title: How to remove blank rows from SQL result set
body: <p>I have a query like this:</p>
  
  <pre><code>SELECT DISTINCT 
      [F_Exhibitor_Name] 
  FROM 
      [V_ExhibitorLocation] 
  WHERE 
      F_ExhibitionCode ='10996' 
    AND 
      [F_Exhibitor_Name] IS NOT NULL
  ORDER BY 
      F_Exhibitor_Name
  </code></pre>
  
  <p>My first line is blank, which causes an error in the code. My current result set looks like this:</p>
  
  <p><img src="https://i.stack.imgur.com/wcsdF.png" alt="enter image description here"></p>