title: CASE statement with multiple THEN's
body: <p>I am using the following SQL to try and accomodate multiple scenarios for an input parameter.</p>
  
  <pre><code>AND ec.eventId in (CASE WHEN @event = 'test_reeq' THEN 223
                          WHEN @event = 'test_NT' THEN 224
                          WHEN @event = 'Both' then '223,224'
                          WHEN @event = 'All' THEN ec.EventId
                          end
                          )
  </code></pre>
  
  <p>My trouble appears to be with my attempt to use the 'both' input. SQL does not like the comma, and I've tried using parentheses instead of single quotes, as well as no quotes, but still no luck. Is it even possible to do what I'm trying to do?</p>
  
  <p>For a bit more info: The EventId itself is an integer data type in the DB. For sake of convenience for user (this will ultimately be an SSRS report), I'd like to have the option for having these two ID's (223,224) grouped by using the keyword 'Both'. I am aware that in SSRS, I could just do a multi-select and even maybe have those two selected by default, but I'd prefer to have them grouped together as an option.</p>