Re: Use index for upper(customername) like 'ABC%'

["Andrus" <kobruleht2@xxxxxx>]

> 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