Re: SQL Command

[Quoted] "Wayne Hinch" <hinchy2000_at_lineone.net> wrote in message news:b5nbn0$j02$1_at_sparta.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
>
>
Try the UPPER() command Received on Mon Mar 24 2003 - 19:57:24 CET