Function Based Indexes w/in UTF environment

In 8i+, you supposedly can create a function based index so that a SQL statement such as the following will still use an index:

Select * from audience_members where upper(last_name) = 'SMITH'

I need to know if this works on a UTF database and what happens when the where clause is multi-byte data.

Any and all help would be very appreciated! Received on Tue Oct 15 2002 - 10:53:09 CDT