Hannu Krosing wrote:
> Constantin Teodorescu wrote:
> > Is there for PostgreSQL a modifier(parameter) that will make the LIKE
> > clause case insensitive ?
> 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 ..
FLEX Consulting Braila, ROMANIA
In response to
pgsql-interfaces by date
|Next:||From: Hannu Krosing||Date: 1999-10-31 12:35:47|
|Subject: Re: [INTERFACES] Case insensitive LIKE ?|
|Previous:||From: Constantin Teodorescu||Date: 1999-10-31 12:10:16|
|Subject: Case insensitive LIKE ?|