This works for shure! WHERE SUBSTRING(LCASE(Customer.name1), 1, LENGTH(?1)) = LCASE(?1)
I hope this can be helpfull to someone. cya, kiuma 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 > > > > > > > > ------------------------------------------------------- > 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 > . > ------------------------------------------------------- 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