>Hi Nadya
>
>>I agree with you, but yesterday we discovered some really nasty indexes like ALLTRIM(UPPER(c_lName)) with FOR conditions.
>
>I see nothing particularly nasty there. UPPER(ALLTRIM()) is supposed to be faster because there are less characters to upper. The FOR conditions automatically suppress Rushmore, but if the code is using seeks for everything, then you'll definitely be breaking stuff.
We're not using seeks in this project. Mostly local views.
If it's not broken, fix it until it is.
My Blog