Re: [SQL] Case insensitive searchs

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 <alewis@themecca.net>
To: <pgsql-sql@hub.org>
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.
>
>
>
>
>