title: Stored Procedure For Report
body: <p>In my stored procedure of sql server, below code is having issue</p>
  
  <pre><code>SELECT NULL AS s_empname
  UNION
  SELECT s_empname FROM ps_OFFICE 
  </code></pre>
  
  <p>In this, I am not getting <code>NULL</code> as first option as it is not a string. If I pass it as:</p>
  
  <pre><code>SELECT ('NULL') AS ps_name
  UNION
  SELECT ps_name  ps_OFFICE
  </code></pre>
  
  <p>It is not working.</p>
  
  <p>How can I update the first one in such a way that  <code>NULL</code> must be <code>s_empname</code> but must be shown in drop-down list of report as  'NULL' or 'No job'?</p>