Re: Case sensitive where clause

Hi!

This way, field = upper('x'), when you able to store only upper-case values in that field is much better, because the other way cause the Oracle suppress index use to search the table. Usually, this means that a Full Table scan will occur.

Best Regards,

Regis Vaz
regis.vaz_at_zaz.com.br

Serge wrote:

> If you are able to store only upper-case values in that field, that it would
> be much better:
>
> select * from table where field = upper(value)
>
> Fredy Tschui ÐÉÛÅÔ × ÓÏÏÂÝÅÎÉÉ <7d8gjp$ijv$1_at_sibyl.sunrise.ch> ...
> >Is there any way to prevent case sensitive results from a where clause ?
> >
> >The following results are different:
> > select * from table where field = "X"
> > select * from table where field = "x"
> >
> >Thanx, Fredy
> >
> >
> >
Received on Tue Apr 06 1999 - 18:36:39 CDT