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 ?
A:
So combine it with toUpperCase() then perhaps field.toUpperCase().startsWith("AB")
Edit : fix method names
DataNucleus
2010-05-19 14:42:13
omg why didn't I think of combining like with any extensions methods. I feel really dumb now. The methods name are toUpperCase()/toLowerCase().Thanks
DrDro
2010-05-19 15:04:52
Simple rule for JDOQL : think how you would express a condition in Java, and then check that all methods and operators are available in JDOQL - they usually are.
DataNucleus
2010-05-20 12:24:16