Re: [GENERAL] Case insensitive "contains" search - Mailing list pgsql-general

Hi!

On Mon, 9 Nov 1998, Wim Ceulemans wrote:
>
> select * from tablex where name = '%test%';
>
> When I want exactly the same but case insensitive, how do I do that? By

   Convert all to uppercase. Something like
select * from tablex where UPPER(name) = '%TEST%';

Oleg.
----
    Oleg Broytmann  National Research Surgery Centre  http://sun.med.ru/~phd/
           Programmers don't die, they just GOSUB without RETURN.