Re: case insensitive matching

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