Re: Case sensitivity issue

Use: ILIKE

Michael Gay wrote:

> If I am doing a command such as
>
> select * from Apples where color like '%red%';
>
> how do I make it case insensitive?
>
> Thanks.
>
> mike