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(at)sundog(dot)larc(dot)nasa(dot)gov>
To: <pgsql-general(at)postgresql(dot)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(at)sundog(dot)larc(dot)nasa(dot)gov