Hello,

 

could anyone help me with the following problem:

 

When I do a SELECT query and I search for e.g. “Detroit” but the data in the derby db is “detroit” then the query has no results.

Is there a way to bypass this, so when querying the database it does not look at uppercases or lowercases. è Detroit = detroit = dEtRoIt = …

 

Help would be appreciated.

 

Thx,

Peter