Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28])
	by postgresql.org (8.11.3/8.11.1) with SMTP id f44IxVA99568
	for <pgsql-admin@postgresql.org>; Fri, 4 May 2001 14:59:31 -0400 (EDT)
	(envelope-from pgsql-admin-owner@postgresql.org)
Received: from webmail.speakeasy.net (webmail.speakeasy.net [216.254.0.19])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f44FCxA25582
	for <pgsql-admin@postgresql.org>; Fri, 4 May 2001 11:12:59 -0400 (EDT)
	(envelope-from tsattler@speakeasy.net)
Received: from localhost.localdomain (localhost.localdomain [127.0.0.1])
	by webmail.speakeasy.net (8.9.3/8.9.3) with SMTP id IAA22056
	for <pgsql-admin@postgresql.org>; Fri, 4 May 2001 08:12:54 -0700
From: tsattler@speakeasy.net
Message-Id: <200105041512.IAA22056@webmail.speakeasy.net>
Subject: Queries
Content-transfer-encoding: 7bit
To: pgsql-admin@postgresql.org
Content-type: TEXT/PLAIN; charset=US-ASCII
Mime-version: 1.0
Reply-to: 
Date: Fri, 4 May 2001 08:12 -0700
X-mailer: Speakeasy Network Webmail v1.0 [J. Beck, G. Morris]
X-Archive-Number: 200105/17
X-Sequence-Number: 1347

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?

I'm on 7.0.3.

Thanks in advance,
Tom Sattler