Does anyone know how to build a query in EJB-QL on which a string comparsion is done in a case-insensitive way? I use dynamic queries under BEA Weblogic v.7.0.
I work with Websphere Application Server 4.0 and DB2 7.1, and in the finder descriptor (ibm-ejb-jar-ext.xmi file for me) says:
ejbqlQueryString="select e from MyTableBean e where ucase(e.description) = ?1"
This descriptor turns uppercase the query result, and when calling the finder method I turn uppercase the parameter (?1), so that I'm comparing both strings uppercase.
Hope it works for you.