Like

SQL

SELECT CSUSER01.CSUSERNO AS entityKey
  FROM CSUSER CSUSER01
 WHERE (CSUSER01.FIRSTNAME LIKE 's%' ESCAPE '\')

XML query API

 <query alias="testLike" projectedClass="com.taleo.akirademo.entity.Candidate">
         <projections>
             <projection alias="entityKey" tag="entityKey">
                 <key path=""/>
             </projection>
         </projections>
         <filterings>
             <filtering>
                 <matches>
                     <field path="firstName"/>
                     <string>s*</string>
                 </matches>
             </filtering>
         </filterings>
    </query>