Re: create index with lowercase

From: Jörg Schneider <oracle_news.3.joesch_at_spamgourmet.com>
Date: Mon, 4 Nov 2002 15:52:04 +0100
Message-ID: <aq61jl$5mj$1@newsreader2.netcologne.de>

Hello together,

thank you for your solutions but both solutions are no practicable. The first one makes the database to big and the second solution ist not felexible.

thank you and i am hoping for more ways (what an english ;-))

Jörg Schneider

"Laly" <laly.kattoor_at_bnpparibas.com> schrieb im Newsbeitrag news:20021030-15813-423147_at_foorum.com...
>
> Hi,
>
> Otherwise you can try this :
> if you want to look for names beginning with A :
> select *
> from my_table
> where name like 'A%' or name like 'a%'
>
> this will use index on name.
> You can generalize : looking for names beginning with AA :
> where name like 'AA%' or name like 'Aa%' or name like 'aA%' or name like
'aa%'
> ..
>
>
>
> HTH,
>
>
> Laly.
>
>
> --
> Use our news server 'news.foorum.com' from anywhere.
> More details at: http://nnrpinfo.go.foorum.com/
Received on Mon Nov 04 2002 - 08:52:04 CST