Function Based Index in Oracle 8

Hi,
I want to make my text search case insensitive but sine the index wont be used if I use the upper() function. Is it possible to have function based index or any workaround in oracle 8. I know it is possible in 8i.

Thanks
Anurag

also reply at
anurag_at_synergy-infotech.com

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!