I am having trouble getting a simple string comparison to work in an SQL "where" clause. It is my understanding that queries are case sensitive by default and I do not want that, so I am constructing the query as follows...
SELECT e FROM Exercise AS e WHERE UPPER(e.name) = ?0
and then I am converting the parameter (representing by position ?0) to upper case. I am certain the parameter value is correct, and there should be a matching record in the database, but my query returns no result.
Is there a more appropriate way to do simple case-insensitive queries using JPA?