Received: from desertmoon.com (qmailr@desertmoon.com [198.182.124.2]) by hub.org (8.9.2/8.9.1) with SMTP id QAA77701 for ; Mon, 8 Feb 1999 16:51:02 -0500 (EST) (envelope-from pierre@desertmoon.com) From: pierre@desertmoon.com Received: (qmail 11595 invoked by uid 100); 8 Feb 1999 21:57:23 -0000 Message-ID: <19990208215723.11594.qmail@desertmoon.com> Subject: Quickie To: pgsql-sql@postgreSQL.org Date: Mon, 8 Feb 1999 14:57:22 -0700 (MST) X-Mailer: ELM [version 2.4 PL25] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Hi all...here is a quickie for ya: Given: User_Email|User_ID ------------------- fubar | 1 barfu | 2 snafu | 3 Fubar | 4 What query could I use to return ONLY 'fubar' and 'Fubar'? Would I do a self join? The problem is that I'd forgotten to force everything to lowercase upon insertion, and now I need to clean out the uppercase records and/or convert them to lowercase. Ideas? -=pierre