Bryan Pendleton wrote:
I store my critical string fields twice, in two separate columns, one
column has the user-desired case, and the other column has the same data
in all upper case.
Then, when I want to search without considering case, I take my search
terms, convert them to all upper case, and search against the upper-case
column.
That's what I thought, thanks for the confirmation. One question: if I
use something like
where upper_col = UPPER(?)
will Derby still use an index, or should I convert the case of the
search term externally then do
where upper_col = ?
Thanks,
--
Alan Burlison
--
