title: Return a value if no rows are found in Microsoft tSQL
body: <p>Using a <em>Microsoft</em> version of SQL, here's my simple query. If I query a record that doesn't exist then I will get nothing returned. I'd prefer that false (0) is returned in that scenario. Looking for the simplest method to account for no records.</p>
  
  <pre><code>SELECT  CASE
              WHEN S.Id IS NOT NULL AND S.Status = 1 AND (S.WebUserId = @WebUserId OR S.AllowUploads = 1) THEN 1
              ELSE 0
          END AS [Value]
  
          FROM Sites S
  
          WHERE S.Id = @SiteId
  </code></pre>