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