SQL Command

From: Wayne Hinch <hinchy2000_at_lineone.net>
Date: Mon, 24 Mar 2003 16:28:16 +0000 (UTC)
Message-ID: <b5nbn0$j02$1_at_sparta.btinternet.com>



Hi,

[Quoted] I have a table which has a description field and it holds descriptions which [Quoted] 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
[Quoted] WHERE description LIKE '%apples%';

[Quoted] Any help will be much appreciated

Wayne Received on Mon Mar 24 2003 - 17:28:16 CET

Original text of this message