function index concepts - urgh

[Dennis Taylor]

I'm having just a little trouble with concepts here. I've created a table with FIRST_NAME and LAST_NAME fields. I want to be able to index the table using

create index HOLDER_NAME_IDX on HOLDER (UPPER(LAST_NAME||' '||FIRST_NAME));

In other words I want to be able to store data as mixed upper & lower case, and I want to be able to look it up using mixed upper and lower case. I'm a little confused about the select statements, though. If I say:

insert into holder (last_name,first_name) values ('taylor','dennis');

then

select * from holder where last_name = 'Taylor' and first_name = 'Dennis';

is that going to use the index? Or do I have to torque the select statement a little more? Or is there a better way to set up the index? Or is the problem just that it's friday? or maybe Friday?





Dennis Taylor
--------------------------------
ILLEGITIMUS NON CARBORUNDUM.

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).