title: How to create a "fake" row in a SELECT statement of a stored procedure
body: <p>I have a stored procedure <code>proc_Audit_GetAppEmployedRelative</code>, the purpose of which is to return previous applicants relatives info. The following <code>SELECT</code> statement is from the procedure:</p>
  
  <pre><code>Select  a.RowID, 
          a.ApplicantRowID,
          a.RelativeName as SearsRelName,
                  Case When a.RelativeName &lt;&gt; 'N/A' then 'Yes' End as RelY,
                  Case When a.RelativeName = 'N/A' then 'Yes' End as RelN,
          a.Relationship as SearsRelRelation,
                  a.RelativeJob as SearsRelJobType,
          a.RelativeLoc as SearsRelJobLoc
      From dbo.App_EmplRelative a(nolock)
      Where a.ApplicantRowID = @ApplicantRowID
  </code></pre>
  
  <p>I have a requirement to return <code>RelN = Yes</code> even if other fields are empty in the table <code>App_EmplRelative</code>. Basically applicant do not have any employed relative information. I just have to fake a row to get <code>RelN = Yes</code> on the form. Please let me know how do I make a fake row, also I still need the above select statement in the proc.</p>