title: Display all IN operator value, with status of 'available' or 'not available'
body: <p>I have list of string like <code>('222','333','43242','3242')</code> which I have to used in a table <code>dummy</code>, let say my table dummy has only two values from this list <code>('222','333')</code>, the data should be show as</p>
  
  <pre><code>dummyID    dummyStatus
  222        Available
  333        Available 
  43242      Not Available
  3242       Not Available
  </code></pre>
  
  <p>I have tried all possible query like</p>
  
  <pre><code>select dummyId, case when dummyId is null 'Available' else 'Not Available' end
  from dummy
  where dummyId in ('222','333','43242','3242')
  </code></pre>
  
  <p>but this doesn't work.</p>