Currently I think that you would have to use BySQL. Feel free to file a ticket on it.
On Mon, Aug 17, 2009 at 1:24 PM, Naftoli Gugenheim <[email protected]>wrote: > I'm using H2, and LIKE queries seem to be case sensitive. What should I do > to search fields without being case sensitive?For example, right now I > have: > Client.findAll(Like(field, "%"+v+"%")) > In SQL I can write SELECT FIRST FROM CLIENT WHERE UPPER(FIRST) LIKE '%A%'; > So is there a way to specify a database function in a query (without using > SQL)? > Thanks. > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Lift" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/liftweb?hl=en -~----------~----~----~----~------~----~------~--~---
