Received: from flex.flex.ro (IDENT:root@[193.230.255.4])
	by hub.org (8.9.3/8.9.3) with ESMTP id GAA49340
	for <pgsql-interfaces@postgresql.org>;
	Sun, 31 Oct 1999 06:30:42 -0500 (EST) (envelope-from teo@flex.ro)
Received: from flex.ro (IDENT:teo@teo.flex.ro [193.230.255.3])
	by flex.flex.ro (8.9.3/8.9.3) with ESMTP id NAA09164;
	Sun, 31 Oct 1999 13:32:34 +0200
Sender: teo@flex.flex.ro
Message-ID: <381C3665.572E14EF@flex.ro>
Date: Sun, 31 Oct 1999 14:30:29 +0200
From: Constantin Teodorescu <teo@flex.ro>
Organization: FLEX Consulting Braila
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.12 i586)
X-Accept-Language: en
MIME-Version: 1.0
To: Hannu Krosing <hannu@tm.ee>
CC: PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] Case insensitive LIKE ?
References: <381C31A8.34A17B8E@flex.ro> <381C37A3.EC9D5D4D@tm.ee>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hannu Krosing wrote:
> 
> Constantin Teodorescu wrote:
> >
> > Is there for PostgreSQL a modifier(parameter) that will make the LIKE
> > clause case insensitive ?
> 
> Maybe
> 
>  select * from t where lower(name) like 'john%';

Yes, it may work, but probably lower(name) won't work on ODBC->MS Access
...
I would like to preserve also the SQL commands betwen versions and not
to fill my program with IF's ..

-- 
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA