> CREATE INDEX ie_cust_upper_name ON customer ( UPPER( customername ) )> WHERE ( UPPER(customername) LIKE 'ABC%' );
ABC is different at every time.
This is first letters of customer name entered by user.So I cannot add ABC to index.
Andrus.