Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: create index with lowercase
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
![]() |
![]() |