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
>
>