users@glassfish.java.net

Re: jpql Query ignore case

From: Mitesh Meswani <Mitesh.Meswani_at_Sun.COM>
Date: Wed, 30 Apr 2008 10:59:40 -0700

How about - select e from Entity e where UPPER(e.attr) = UPPER(parameter)

glassfish_at_javadesktop.org wrote:
> Hello everyone. I just want to know the correct syntax for the jpqlQuery in postgresql to ignore the case of the parameter. I tried researching but haven't found the answers yet:
>
> How to transform the ff in jpql:
>
> select * from table_name where column ilike 'parameter'
>
> so if the parameter is spelled PaRaMEter. i will ignore the case and show all the column match.
>
> Thank you,
> Rai
> [Message sent by forum member 'riyanne_90210' (riyanne_90210)]
>
> http://forums.java.net/jive/thread.jspa?messageID=272184
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
>