Re: Case insensitive LIKE queries

select * from myTable where upper(myField) like 'TEST';

Upper will change the fields to upper case for testing purposes.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "Yann Ramin" <atrus(at)atrustrivalie(dot)eu(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, November 01, 2000 12:05 AM
Subject: [GENERAL] Case insensitive LIKE queries

> Hello,
>
> What would be the most effective way of preforming a case-insensitive LIKE
> query? I've notived that MySQL somehow ALWAYS does it case insensitive,
> which is not very smart, but I should expect this feature to exist without
> reasonable pain on the programmer;s end?
>
> Yann
>
> --
>
> --------------------------------------------------------------------
> Yann Ramin atrus(at)atrustrivalie(dot)eu(dot)org
> Atrus Trivalie Productions www.redshift.com/~yramin
> AIM oddatrus
> Marina, CA http://profiles.yahoo.com/theatrus
>
> IRM Developer Network Toaster Developer
> SNTS Developer KLevel Developer
> Electronics Hobbyist person who loves toys
>
> Build a man a fire, and he's warm for a day.
> Set a man on fire, and he'll be warm for the rest of his life.
>
> "I'm prepared for all emergencies but totally unprepared for everyday
> life."
> --------------------------------------------------------------------
>
>
>
>
>
>
>