Re: Case Sensitivity in select

The only thing that I would add is that some query optimizers will do full table scans when you use a function in the where clause - even when an index exists!

You may wish to keep the proper case column and introduce an uppercase version of the proper case column. Create an index on the upper case column and always do lookups on the upper case column thereby eliminating the need to dispatch any functions in the where clause. To be on the safe side, introduce an insert/update trigger that maintains the uppercase column.

Hope this helps,

Matt

Darren Roche <darren.roche_at_cableol.co.uk> wrote in message news:7qk3sh$hmt$1_at_nclient9-gui.server.ntli.net...
> 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 Mon Sep 06 1999 - 22:12:46 CDT