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