Alan Burlison <[EMAIL PROTECTED]> writes: > 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 = ?
Both of the above queries would normally use the index on upper_col, if such an index is present. -- Knut Anders