Re: How to Disable Case sensivity for string compare ?

The problem is that this query make a full table scan:

SELECT list_of_fields

    FROM table_name
    WHERE upper(field_name) = upper('text_to_search')

You can try something like this if the field to search is indexed:

SELECT      /*+ INDEX(table_name index_name) */   list_of_fields
    FROM     table_name
    WHERE  (field_indexed LIKE 'x%' OR field_indexed LIKE 'X%')
         AND  upper(field_indexed) = upper('text_to_search')

Hope this help,

Javier Rojas.

Em Pradhan wrote:

> hi
> select * from case_checker upper(col1)=upper('kdjfalkfad');
> cheers..
>
> Loy&Hutz wrote:
>
> > I īd like to have the same behaviour like MS access.
> >
> > Is there a possibility / switch to dissable the case sensitivity for all
> > actions
> >
> > e.g.
> >
> > Select * from Tbl1 where Col1 = 'a'
> >
> > ->>>
> > Results with Col11 = 'A' or 'a'
> >
> > Perhaps with sort order ?
> >
> > Greetings Sven Kunze
Received on Fri Nov 20 1998 - 05:14:25 CST