Re: case insensitive searches

In article <3ujekn$319_at_news.cais.com>, randyd_at_cais2.cais.com (Randy Dewoolfson) wrote:

> Anthony Sama (asama_at_netaxs.com) wrote:
>
> : What's the best way to specify case insensivity in a WHERE
> : clause?
>
> To match strings withou regard to case you might try
> WHERE UPPER( string1) = UPPER( string2 )
> or the LOWER equivalent..
>

[SNIP] You may want to bear in mind that the upper function negates the use of any index on a column! One way round this would be to force the entry of the field to upper case, or where this is not appropriate you could denormalise another column into the table holding the same value in upper case for query purposes.

Richard Avery

-- 
The above posting does not represent the views of Nortel in any way.