title: Multiple values in SQL CASE's THEN Statement
body: <p>I am wondering if it is possible to specify multiple values in the then part of a case statement in <code>T-SQL</code>? </p>
  
  <p>I have attached a chunk of code where I am using this to join in some tables in a query. I have included a comment in the snippet.</p>
  
  <pre><code>LEFT JOIN Business B ON v.BusID = B.BusID
  LEFT JOIN BusinessTypeKey T ON B.BusinessTypeID = T.BusTypeID
  LEFT JOIN Location L ON L.BusID = B.BusID
  AND L.HeadQuarters = CASE 
  WHEN (SELECT COUNT(1) from Location L2
  WHERE L2.BusID = B.BusID) = 1                                                                           
  THEN 1,0   -- Would like to specify either 1 or 0 here. I suppose I could also make it euqal to -&gt; L.HeadQuarters but would like a better way to impose it                                                                                                  
  ELSE 1  
  END
  </code></pre>