HI, I hope someone can help me with a frustrating problem.
I cannot seem to get a case insensitive like search to work with Dynamic-QL. The same query works fine with a normal @jboss.query method. Here is the Dynamic QL; "SELECT OBJECT(m) FROM MemberBean AS m WHERE m.organisation.organisationId = ?1 AND (LCASE(m.secondName) LIKE LCASE(?2)) " For example, if the database countains Alan Younger and ?2 is 'younger' then the query returns a result. However, if ?2 is 'young' then no results are returned. Pleeeease Help, Richard Richard Aukland 49 Ravensmere, Beccles, Suffolk, UK. NR34 9BE Tel/Fax. +44(0)1502 470162 Cell. +44(0)7906 094578 mailto: [EMAIL PROTECTED] http://www.aukinfo.com ------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user