Java: JDOQL startsWith query, case sensitive

Question

I'm using the .startsWith() filter in a JDOQL query but it's case sensitive. So startsWith("ab") doesn't return "Abc" result and so on.

Will I need to use a SQL query to avoid this ?

Answer 1

So combine it with toUpperCase() then perhaps field.toUpperCase().startsWith("AB")

Edit : fix method names