Received: from rm-rstar.sfu.ca (root@rm-rstar.sfu.ca [142.58.120.21]) by hub.org (8.9.2/8.9.1) with ESMTP id QAA78793 for ; Mon, 8 Feb 1999 16:56:16 -0500 (EST) (envelope-from gburnham@sfu.ca) Received: from apemantus (apemantus.educ.sfu.ca [142.58.6.61]) by rm-rstar.sfu.ca (8.9.1/8.9.1/SFU-5.0H) with SMTP id NAA24091; Mon, 8 Feb 1999 13:56:08 -0800 (PST) Message-ID: <003401be53ad$d60ee2e0$3d063a8e@educ.sfu.ca> From: "Gregory W Burnham" To: , Subject: Re: [SQL] Quickie Date: Mon, 8 Feb 1999 13:56:09 -0800 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.0810.800 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.0810.800 select User_Email from 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: To: 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 > >