Quickie

pierre@desertmoon.com

From: pierre@desertmoon.com
To: pgsql-sql@postgreSQL.org
Date: 1999-02-08T21:57:22Z
Lists: pgsql-sql
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