title: SQL case statement in a stored procedure
body: <p>I have a SQL Server stored proc that contains a CASE statement. However, I need to append the values if multiple conditions are true.  </p>
  
  <p>So if a particular record has an <strong>Invalid Date</strong> And <strong>Mileage exceeded</strong>, I would like both values to be displayed in the <strong><em>NotArchiveableReason</em></strong> column.  </p>
  
  <p>How would I accomplish that?  </p>
  
  <pre><code>, CASE 
      WHEN DateOfLoss &lt; PolicyStartDate THEN 'Invalid Date'
      WHEN MilesDriven &gt; TotalMilesAllowed THEN 'Mileage exceeded'
      WHEN LossStatusCode != 'R' THEN 'Status code is Review'
      Else 'Unknown issue'
      END
      As NotArchiveableReason
  </code></pre>