Re: create index with lowercase

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/