Re: SQL Command

From: Wayne Hinch <hinchy2000_at_lineone.net>
Date: Mon, 24 Mar 2003 22:35:16 +0000 (UTC)
Message-ID: <b5o174$ojp$1@titan.btinternet.com>

Hi Scott,

Thanks for that it worked a treat.

Wayne

"Scott Mattes" <Scott_at_TheMattesFamily.ws> wrote in message news:vnHfa.8620$TW2.1596252_at_news1.news.adelphia.net...
> 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 - 16:35:16 CST