Received: from nfs1-1.bctel.ca (lakecity-m68.bctel.ca [207.194.28.68]) by hub.org (8.9.2/8.9.1) with ESMTP id OAA75402 for ; Sun, 18 Apr 1999 14:18:22 -0400 (EDT) (envelope-from gburnham@sfu.ca) Received: from lucie (a3a13627.sympatico.bconnected.net [209.53.8.141]) by nfs1-1.bctel.ca (8.9.1a/8.9.1) with SMTP id LAA00175; Sun, 18 Apr 1999 11:18:16 -0700 (PDT) Message-ID: <009501be89c7$91e42da0$8d0835d1@bconnected.net> Reply-To: "Gregory W Burnham" From: "Gregory W Burnham" To: "Andy Lewis" , References: Subject: Re: [SQL] Case insensitive searchs Date: Sun, 18 Apr 1999 11:16:13 -0700 Organization: Excite Labs MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2014.211 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 I'm sure the syntax here is wrong, and I'm sure I'll be corrected : ) But can't you do something like this: select distict from the_table where upper(city_name) = upper("san antonio"); Gregory W Burnham Software Engineer Excite Labs Faculty Of Education Simon Fraser University Vancouver, BC, V5A 1S6 604 291 3615 (ph) 604 291 5679 (fx) ----- Original Message ----- From: Andy Lewis To: Sent: Sunday, April 18, 1999 11:14 AM Subject: [SQL] Case insensitive searchs > I have a table that has city names in it. Some of the cities have a number > of different cases. For instance I may have: > > San Antonio > san antonio > San antonio > SAN ANTONIO > > My question is how can I do a distinct search for all cities and only get > one of each city? > > Thanks in advance. > > > > >