Re: Queries

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