Re: Case Sensitivity in select

Yes, of course.

Try this....

select * from words
where UPPER(word) = 'HELLO';

Where it will bring back all variations i.e. Hello, hello, HeLlO, etc.

Regards,

Darren.
Darren.roche_at_cableol.co.uk

Stu wrote in message <37C524EA.CC828BE7_at_dkmsoft.com>...
>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 Wed Sep 01 1999 - 15:52:49 CDT