Re: Case sensitivity issue

use "ILIKE" instead of "LIKE"
or use a regular expression match: ~* 'red'

----- Original Message -----
From: "Michael Gay" <mike7411(at)earthlink(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Sunday, September 09, 2001 11:02 PM
Subject: [GENERAL] Case sensitivity issue

> If I am doing a command such as
>
> select * from Apples where color like '%red%';
>
> how do I make it case insensitive?
>
> Thanks.
>
> mike
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>