Look at the upper function (hint, on the left side of the LIKE).
"Wayne Hinch" <hinchy2000_at_lineone.net> wrote in message
news:b5nbpq$gj8$1_at_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 - 11:37:31 CST
