Re: SQL Case Insensitive?

From: "Dave de Buys" <NO_SPAM_dave.debuys@xxxxxxxxxxxxxx>
Date: Wed, 1 Feb 2006 16:04:04 +0200

YeS, YoU ArE CoRrEcT,

DaVe


"Jan Pit" <janpit@xxxxxxxxxxxxxxxx> wrote in message
news:43e0b907@xxxxxxxxxxxxxxxxxxxxxxxxx
> Am I right that the ADO SQL is case insensitive?
> SELLECT * FROM MyTable WHERE City LIKE '%ne%'
> finds all with NE, ne, Ne or nE anywhere in the field..
>
> I used before LocalSQL (with BDE), and that one is case sensitive, but it
> allows also the use of the UPPER() function.
> Just LIKE to know if this is correct.
>
> Thanks,
> + Jan Pit +
> Botswana
>
>


.

References:
- SQL Case Insensitive?
  - From: Jan Pit

Prev by Date: Updatebatch question
Next by Date: Re: Please help with a serious issue
Previous by thread: SQL Case Insensitive?
Next by thread: Re: SQL Case Insensitive?
Index(es):
- Date
- Thread

Relevant Pages

SQL Case Insensitive?
... Am I right that the ADO SQL is case insensitive? ... SELLECT * FROM MyTable WHERE City LIKE '%ne%' ... Jan Pit + ...
(borland.public.delphi.database.ado)
Re: SQL Case Insensitive?
... Jan Pit wrote: ... > Am I right that the ADO SQL is case insensitive? ... That depends of the underlying database. ... If you use SQL Server it ...
(borland.public.delphi.database.ado)