On Fri, 4 May 2001 tsattler@speakeasy.net 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'.
Isthere 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 <jburton@scw.org>
Director of Information Systems, Support Center of Washington