Re: SELECT question

From: Brian Avis <brian(dot)avis(at)searhc(dot)org>
To: Brian Avis <brian(dot)avis(at)searhc(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SELECT question
Date: 2003-01-30 23:13:35
Message-ID: 3E39B19F.1010208@searhc.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Assuming the data in the text field will resemble any of the following.

Brian K. Avis
Brian Avis
Brian

Or whatever combo.

Brian Avis wrote:

> I want to run a SELECT on a text field and match any of the following.
>
> brian
> Brian
> BRIAN
>
> Or any other combination. How do I tell SQL to ignore case when
> doing a SELECT?
>
>

--
Brian Avis
SEARHC Medical Clinic
Juneau, AK 99801
(907) 463-4049
Have a nice diurnal anomaly!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-01-30 23:16:49 Re: SELECT question
Previous Message Brian Avis 2003-01-30 23:11:36 SELECT question