From: | "Gregory W Burnham" <gburnham(at)sfu(dot)ca> |
---|---|
To: | "Andy Lewis" <alewis(at)themecca(dot)net>, <pgsql-sql(at)hub(dot)org> |
Subject: | Re: [SQL] Case insensitive searchs |
Date: | 1999-04-18 18:16:13 |
Message-ID: | 009501be89c7$91e42da0$8d0835d1@bconnected.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)themecca(dot)net>
To: <pgsql-sql(at)hub(dot)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.
>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andy Lewis | 1999-04-18 18:31:20 | Re: [SQL] Case insensitive searchs |
Previous Message | Andy Lewis | 1999-04-18 18:14:46 | Case insensitive searchs |