title: TSQL - Case - Values in?
body: <p>Is there a way we can specify values in for a case statement? The below statement doesn't execute because it thinks 53,57,82,83 etc are columns.. Is there a work around.. i googled up but found nothing that say you can't use IN case-when expression..</p>
  
  <pre><code>select 
  x =
  case 
      when xvalue in ([52],[57],[82],[83]) 
          then "xvalue"
      when yvalue in ([01],[02],[11]) 
          then "yvalue"
      else
          'NULL'
      end
  from xyztable
  </code></pre>