Received: from oxmail.ox.ac.uk (oxmail1.ox.ac.uk [129.67.1.1])
	by hub.org (8.9.3/8.9.3) with ESMTP id MAA85949
	for <pgsql-interfaces@postgresql.org>;
	Sun, 31 Oct 1999 12:04:26 -0500 (EST)
	(envelope-from moray.mcconnachie@computing-services.oxford.ac.uk)
Received: from heraldgate2.oucs.ox.ac.uk
	([163.1.2.50] helo=frontend2.herald.ox.ac.uk ident=exim)
	by oxmail.ox.ac.uk with esmtp (Exim 2.10 #1)
	id 11hyOk-0004Qt-00; Sun, 31 Oct 1999 17:04:06 +0000
Received: from max96.public.ox.ac.uk ([192.76.27.96]
	helo=mainbox.malthouse.private.net)
	by frontend2.herald.ox.ac.uk with smtp (Exim 2.02 #1)
	id 11hyOk-0008Jx-00; Sun, 31 Oct 1999 17:04:07 +0000
Message-ID: <001901bf23c1$a018bfa0$01c8a8c0@malthouse.private.net>
From: "Moray McConnachie" <moray.mcconnachie@computing-services.oxford.ac.uk>
To: "Constantin Teodorescu" <teo@flex.ro>
Cc: "PostgreSQL Interfaces" <pgsql-interfaces@postgresql.org>
References: <381C31A8.34A17B8E@flex.ro> <381C37A3.EC9D5D4D@tm.ee>
	<381C3665.572E14EF@flex.ro>
Subject: Re: [INTERFACES] Case insensitive LIKE ?
Date: Sun, 31 Oct 1999 17:01:49 -0000
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300


> 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 ..

Why not use Passthrough queries in Access/ODBC, which have pgsql do the SQL
for them and therefore use pgsql's syntax?

Or do you mean that the you are running Access and pgsql both as servers,
rather than Access as front-end?