Re: case insensitive searches

[Stephen Caine]

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