title: Mutliple values for IN clause with CASE in Redshift
body: <p>I am trying to run this query where IN clause uses CASE to choose values between two cases. </p>
  
  <p>The issue is with the hard coded value('aaa','bbb'). I cannot add multiple values inside THEN so it act as regular IN values. The hard code values will be dynamic as I will pass a variable for it.</p>
  
  <pre><code>select kdo.field0
  from tb1 data1 inner join tb2 kdo
  on kdo.field1 = 'xxx'
     and kdo.field2::DATE &gt;='2017-08-01'::DATE
     and kdo.field0
         in (case when 'asd'!='' then 'aaa','bbb'
             else tb2.field0 end);
  </code></pre>
  
  <p>Also, I used a sub-query select inside THEN to get specific hard code values but it is also of no avail. Using single hard-coded value obviously works as usual.</p>