Re: [SQL] case insensitive search

[[EMAIL PROTECTED]]

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