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,
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