> 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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
