Re: Case Sensitivity in select

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 - 12:11:14 CDT