>I do have a UPPER(LastName) index in my table.
>For some reason rushmore doesn't work in this case and I still havn't found the reason why.
>
>I tried it with a view it's doing the exact same thing...
>The strangest thing is that it only take to long in certain searches and not all.
See my first reply to you and Sergey's explanation.
If it's not broken, fix it until it is.
My Blog