>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.