Hibernate version:2.1.3

Currently have a sql-query using the LIKE keyword which appears to only search the beginning of the string as per 'string%' I have a sql-query but would like to search anywhere in the string.

My current query is :

<sql-query name="listSearch"><![CDATA[
select {u.*} from contactinfo c
inner join profiles p on c.id = p.id
WHERE LOWER(u.name) like :searchString
]]>
<return alias="u" class="com.lightning.persistent.User"/>
</sql-query>

Is there a support syntax in 2.1.3 to search anywhere within the string or will I have to drop out to sql for a '%string%' search?

Look forward to your responses.
Cheers

well, just do a setParameter("searchString", "%some%");