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