RE: Indexing on names

Yes you can create function based indexes in Oracle 8 and above (I believe)

CREATE INDEX ..... UPPER( column name ) CREATE INDEX ..... LOWER( column name )

Regards,
Aleem

		-----Original Message-----
		From:	I.S. Manager [mailto:ismgr_at_pctc.com]
		Sent:	27 June, 2000 10:58 PM
		To:	Multiple recipients of list ORACLE-L
		Subject:	Indexing on names

		This seems like it should be a silly question, but you never
know. And I'd
		rather find out now.

		Given a table that needs to be indexed on a field that is
text (names, for
		instance). Can I allow mixed upper/lower case to be stored
in the field,
		and index the table using a function that converts the field
to all upper
		case? (using 8i). Or is there some non-intuitive gotcha that
will either
		prevent this or cause a full-table scan in all cases?