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

Reply via email to