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