Re: case insensitive search

Joern,
select myfield from tablea where lower(myfield) = 'mysearch';
or
select myfield from tablea where myfield ~* 'mysearch';


Troy

>
> Hello together,
>
> how can I handle case insensitive search in a table?
>
>
>
> --
> Linux is like wigwam - no windows, no gates, apache inside.
> In diesem Sinne
>   Joern
>
>
>