I just checked and it should work with 3.0.2. Are you using JBossQL or EJB-QL. This is only supported by the JBoss proprietary extension to EJB-QL as EJB-QL does not support the LCASE functions and does not support LIKE clauses with functions on either side.
If you are using JBossQl in 3.0.2 and it is not working, what error are you getting (just the message not the stacktrace)? -dain Marius Kotsbak wrote: > I have done something like that in 3.0.2 as well, and it seems to work! > > Dain Sundstrom wrote: > >> If you run Branch_3_0 (no binary release yet), you can use this syntax: >> >> LCASE(Customer.name1) LIKE LCASE(?1) >> >> -dain >> >> kiuma wrote: >> >>> How can I render a case insensitive searc ? >>> >>> Customer.name1 LIKE ?1 is case sensitive >>> >>> LCASE(Customer.name1) = LCASE(?1) doesn't match partial pattern matching >>> >>> Thanks, >>> kiuma ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
