title: Is it possible to perform a "LIKE" statement in a SSIS Expression?
body: <p>I'm using a Derived Column Task to change column data using a CASE WHEN statement. However, I need to be able to say..</p>
  
  <p><strong>SQL CODE WOULD BE:</strong></p>
  
  <pre><code>CASE WHEN Column01 LIKE '%i%' THEN '0' ELSE '1' END
  </code></pre>
  
  <p><bR><strong>In SSIS Expression Language that would be:</strong></p>
  
  <pre><code>[Column01] == "i" ? "0" : "1"  (that's for equals i, not, LIKE %i%.
  </code></pre>
  
  <p><br>Is it possible to use a LIKE operator?</p>