>>only with parameters you can have a "wrong estimated" plan in the meaning that was discussed here.
>
>Ok, the resolution in regards to this is as followed. Tonight, as the alternate field is only a digit representation of the main field, we will change it to numeric. It is my assumption that this should be faster. I will simply change the parameterized value on that field to be a numeric value and everything which is equal or greater.

It would supprise me if that works. The problem is SQL server determining the wrong execution plan.