On Mon, Aug 17, 2009 at 12: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.
>
Fresh off the presses:
Cmp[O, String](field, OprEnum.Like, Full(value), Empty, Full("UPPER"))
You can include an SQL function in a Cmp.
>
> >
>
--
Lift, the simply functional web framework http://liftweb.net
Beginning Scala http://www.apress.com/book/view/1430219890
Follow me: http://twitter.com/dpp
Git some: http://github.com/dpp
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
