Re: Case Sensitivity in select
From: Jiliang Chiu <lchiu_at_bellsouth.net>
Date: 1999/08/26
Message-ID: <sDdx3.4816$_W4.20661_at_news1.atl>#1/1
Date: 1999/08/26
Message-ID: <sDdx3.4816$_W4.20661_at_news1.atl>#1/1
Select string, UPPER(string), LOWER(string), INITCAP(LOWER(string)) from string_table;
JC
Eike J. Heinze <eike.heinze_at_compuware.com> wrote in message
news:37C56116.4791F15C_at_compuware.com...
> Stu,
>
> I don't know of any general parameter of this sort.
>
> Regards
> Eike
>
> Stu wrote:
>
> > Is it possible to set a parameter which will make a select statement
> > case insensitive. i.e. so that select * from words where word='hello'
> > will bring back records where word='HELLO' or 'Hello'.
>
Received on Thu Aug 26 1999 - 00:00:00 CEST