title: CASE Statement with multiple outcomes - some outcomes overlooked
body: <p>I have a case statement such as the one below that has multiple outcomes. Unfortunately, due to the first three outcomes being satisfied, the other options are being ignored. Is there some way of the statement considering all outcomes?</p>
  
  <pre><code> ,CASE WHEN T.T1_HoNOSCA_Score IS NULL THEN 'Missing T1'
      WHEN T.T2_HoNOSCA_Score IS NULL THEN 'Missing T2'
      WHEN T.T1HonosValidity IN ('NULL','Invalid 9','Invalid Null') 
      OR T.T2_HonosValidity IN ('NULL','Invalid 9','Invalid Null') THEN 'Invalid Data'
      WHEN T.T1_HoNOSCA_Score IS NULL AND T.T2_HoNOSCA_Score IS NULL THEN 'Missing T1 &amp; T2'   
      WHEN T.T1_HoNOSCA_Score IS NULL AND T.T1HonosValidity IN ('NULL','Invalid 9','Invalid    `enter code here`Null') 
      OR T.T2_HonosValidity IN ('NULL','Invalid 9','Invalid Null') THEN 'Missing T1 &amp; Invalid Data'
      WHEN T.T2_HoNOSCA_Score IS NULL AND T.T1HonosValidity IN ('NULL','Invalid 9','Invalid Null') 
      OR T.T2_HonosValidity IN ('NULL','Invalid 9','Invalid Null') THEN 'Missing T2 &amp; Invalid Data'
      WHEN T.T1_HoNOSCA_Score IS NULL AND T.T2_HoNOSCA_Score IS NULL AND T.T1HonosValidity IN ('NULL','Invalid 9','Invalid Null') 
      OR T.T2_HonosValidity IN ('NULL','Invalid 9','Invalid Null') THEN 'Missing T1 &amp; T2 &amp; Invalid Data'
      ELSE NULL END AS Data_Quality_Type
  </code></pre>