title: How to use SQL Like Operator in IBatis 2?
body: <p>Could somebody explain to me, how it is possoble to use the SQL Like operator in IBatis 2?</p>
  
  <p>I want to execute some SQL code like this (I want to search something in columnA, which will be started with letter H):</p>
  
  <pre><code>SELECT table1.columnA,
         table1.columnB          
  FROM   table1
  WHERE  table1.columnA LIKE H%
  </code></pre>
  
  <p>I have tried this IBatis code, but it doesn´t work (I use an oracle database) :</p>
  
  <pre><code>&lt;select id="selectExecuting" resultMap="myOenResultmap" parameterClass="java.util.Map"&gt;
      SELECT table1.columnA,
             table1.columnB          
      FROM   table1
      WHERE  table1.columnA LIKE '%$H$%'
  &lt;/select&gt;
  </code></pre>