Hi All,
I am getting exception when using 'like' operator with 'upper' function in JPA sQL.
Below SQL is working
select * from Customer customer where UPPER(customer.custName)= UPPER(:custName)
If i change '=' to like in the above SQL its not working.
select * from Customer customer where UPPER(customer.custName) LIKE UPPER(:custName)
and getting below exception..
Caused by: org.apache.openjpa.persistence.ArgumentException: Encountered "UPPER ( customer . custName ) LIKE UPPER" at character 90,