Your best bet is to create a function based index eg create index my_idx on
myTable(upper(theColumn)...
then you can search like
select .. from myTable where upper(theColumn) like 'HA%';
you need to set query_rewrite=trusted and analyze the table.
Jim
"John Harris" <harris.john.a_at_worldnet.att.net> wrote in message
news:iGJ48.4247$Ab1.269199_at_bgtnsc04-news.ops.worldnet.att.net...
> How does one handle case sensitivity with string searches using the LIKE
> operator?
> If I have something like: select * from employee where lastname LIKE "ha%"
> But I want to get all possibilities regardless of case sensitivity -
harris,
> Harris HArris HARRIS haRRis...
>
> Is this possible with straight SQL against an Oracle database?
>
> John Harris
>
>
Received on Sat Jan 26 2002 - 21:20:42 CST
