On Fri, 4 May 2001 [EMAIL PROTECTED] wrote:
> Greetings All.
>
> I have a record on my database with a last name of 'DeFelice'.
>
> I want to be able to retrieve that record whether a user enters 'DeFelice',
>'Defelice', 'defelice', or 'DEFELICE'. Is there a way I can do that? Is that what
>the "ilike" function does?
CREATE INDEX lname_lower ON person ( lower(lname) );
(above step is optional, but helps performance)
SELECT * FROM person WHERE lower(lname) = 'defelice'
should be faster than ILIKE.
--
Joel Burton <[EMAIL PROTECTED]>
Director of Information Systems, Support Center of Washington
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
