It is in the list archives several times.
All you need is to use some basic SQL.
select * from mytable where upper('my criteria') = upper(mytable.info);
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "David Reid" <dreid@jetnet.co.uk>
To: <pgsql-general@postgresql.org>
Sent: Wednesday, February 14, 2001 9:58 AM
Subject: [GENERAL] Case insensitive selects?
> Does pgsql support this and how would I do it?
>
> david