Re: [SQL] Quickie

select User_Email from <whatever your table name is> where User_Email ~*
'fubar';

I think, I haven't tried it yet.

Gregory W Burnham
Software Engineer
Excite Labs
Faculty Of Education
Simon Fraser University
Vancouver, B.C.
(604) 291 3615 ph
(604) 291 5679 fx
----- Original Message -----
From: <pierre@desertmoon.com>
To: <pgsql-sql@postgreSQL.org>
Sent: Monday, February 08, 1999 1:57 PM
Subject: [SQL] Quickie


>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
>
>