title: Force a SQL Server query to return no rows
body: <p>I have the following query:</p>
  
  <pre><code>SELECT 
       CASE
            WHEN ([DBO].fn_WorkDays(GETDATE(), DATEADD(d, 1, EOMONTH(GETDATE()))) = 2)
                 THEN 1
       END
  </code></pre>
  
  <p>That should return 1 if the condition is true (obviously), but I want it to return nothing (no rows) if false. Instead, it's returning a null row. How do I force it to return 1 or nothing?</p>