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