Re: case insensitive matching - Mailing list pgsql-general

From Adam Lang
Subject Re: case insensitive matching
Date
Msg-id 00c001c02d59$7e9afe40$330a0a0a@6014cwpza006
Whole thread Raw
In response to case insensitive matching  (Robert Kernell <kernell@sundog.larc.nasa.gov>)
List pgsql-general
Can you use an uppercase function?

Something like: select * from table where upper(columnname) like 'SEARCH';

Can this be done in postgres?

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "Robert Kernell" <kernell@sundog.larc.nasa.gov>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, October 03, 2000 12:41 PM
Subject: [GENERAL] case insensitive matching


> Hi. LIKE does case sensitive string matching. Is there an easy way to do
case
> insensitive string matching?
>
> Bob Kernell
> Research Scientist
> AS&M
> email: kernell@sundog.larc.nasa.gov


pgsql-general by date:

Previous
From: Tod McQuillin
Date:
Subject: Re: case insensitive matching
Next
From: "Mitch Vincent"
Date:
Subject: Re: case insensitive matching