SQL Command

From: Wayne Hinch <hinchy2000_at_lineone.net>
Date: Mon, 24 Mar 2003 16:29:46 +0000 (UTC)
Message-ID: <b5nbpq$gj8$1@titan.btinternet.com>

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 Received on Mon Mar 24 2003 - 10:29:46 CST