Stephen Caine wrote:
Terry,
Is it possible to set Derby to do case-insensitive searches? The
default seems to be case-sensitive. This would be fine as a global
setting that never needs to change.
Are you using 'starts with', 'contains' or 'equals'? These operators
tend to be case sensitive. Can you use 'like'? This is case insensitive.
Stephen Caine
Soft Breeze Systems, LLC
You can also use UPPER function in your query predicate as in:
... AND UPPER(name) = 'CAINE' ....
--
Regards,
Farrukh
Web: http://www.wellfleetsoftware.com
Blog: http://farrukhnajmi.blogspot.com
