Re: SQL Command

From: Marc Melancon <mmelanco_at_videotron.ca>
Date: Mon, 24 Mar 2003 15:16:52 -0500
Message-ID: <UIJfa.31961$cc1.369533@wagner.videotron.net>

Use Oracle built in function UPPER.

MarcM

"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 - 14:16:52 CST