Hi All,
I wish to avoid a full tablescan on the following data
V. Zanen
Zanen
Van Zanen
...
...
...
Lot's more data
Select * from table where upper(name) like '%ZANEN%'
I could create a function based index on upper(name) but this does not take care of the % and like operator.
Oracle has this (I believe it's called) context stuff that you can index varchar fields etc. Is this the (only possible?) way to go??
TIA
Jack
