Re: SQL Command

From: Eric Kimble <ekimble_no_spam_at_wfl.fha.dot.gov>
Date: Mon, 24 Mar 2003 12:43:41 -0800
Message-ID: <3E7F6DFD.6BAEE9DE@wfl.fha.dot.gov>

Wayne Hinch wrote:

> Hi,
>
> I have a table which has a description field and it holds descriptions which
> have a mixed case.
>
> How do I make them all uppercase or make a SQL command which is not case
> sensitive. I.e. The SQL statement below will display all records which
> contain the word apples but it will not work if the description is Apples or
> APPLES.
>
> SELECT description
> FROM stock
> WHERE description LIKE '%apples%';
>
> Any help will be much appreciated
>
> Wayne

SELECT description
FROM stock
WHERE UPPER(description) LIKE '%APPLES%'; or

SELECT description
FROM stock
WHERE LOWER(description) LIKE '%apples%'; Received on Mon Mar 24 2003 - 14:43:41 CST