Index usage

[bhabani s pradhan]

Hi All,

I have the query like:

SELECT *
FROM tab1
WHERE UPPER(col1) <> 'abc';

Obviously, the function based index i have is not hetting used because of the 
ineqality.

When using 
SELECT *
FROM tab1
WHERE UPPER(col1) <> 'abc';

index is getting used.

How can I possibly use index in the 1st case.


Thanks and Regards,
B S Pradhan