Re: SQL Command

From: Wayne Hinch <hinchy2000_at_lineone.net>
Date: Mon, 24 Mar 2003 22:35:27 +0000 (UTC)
Message-ID: <b5o17f$iv9$1@hercules.btinternet.com>

Hi Marc,

Thanks for that it worked a treat.

Wayne

"Marc Melancon" <mmelanco_at_videotron.ca> wrote in message news:UIJfa.31961$cc1.369533_at_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 - 16:35:27 CST