title: Can I select multiple columns depending on a SELECT CASE?
body: <p>Based on the SELECT CASE below I want to show <strong>two</strong> separate columns within one WHEN. Is this possible?</p>
  
  <p>The two commented out lines below are something like what I would like to have. I am sure it is something very simple I am missing. As it is, there is a syntax error.</p>
  
  <pre><code>select 
      person.FirstName,
      person.LastName,
      CASE 
          --WHEN substatus is not null then 'HasSubstatus', null
          --else null, 'DoesNotHaveSubstatus'
          WHEN substatus is not null then 'HasSubstatus'
          else null
      end
  from Person person
  </code></pre>