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@atrustrivalie.eu.org>
To: <pgsql-general@postgresql.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@atrustrivalie.eu.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."
> --------------------------------------------------------------------
>
>
>
>
>
>
>
