QL Finder not case-sensitive?

[vanne]

Hi, I try to build a not case-sensitive Finder but it doesn't work this way:


<query-method>
<method-name>findByKennung</method-name>
<method-params>
<method-param>java.lang.String</method-param>
</method-params>
</query-method>
<jboss-ql>
<![CDATA[
SELECT OBJECT(b) FROM BenutzerBean b
WHERE UCASE(b.implKennung) = UCASE(?1)
]]>
</jboss-ql>


I also tried

<jboss-ql>
<![CDATA[
SELECT OBJECT(b) FROM BenutzerBean b
WHERE UCASE(b.implKennung) LIKE UCASE(?1)
]]>
</jboss-ql>

I would like to be able to find 'test' and 'Texas' with 't%' but I do find this way only 'test' ;-(

[vanne]

Ooops, my mistake! It works! Sorry