Brian Candler wrote:
> Thanks, not a bad idea, although I imagine that Oracle would not use the
> indexes at all in that case, which for a million-record database is a bit of
> a problem.

That's why Oracle let you create function based indexes, e.g. you can 
create an index on UPPER(foo). :) But this is going probably way off 
topic now :).

Regards,

Peter