>I understand but part of the problem is that I also have the user select which order he wants to see the data in and there are many ways in which date is not used.
>
>>You should have index tag on VAL(LEFT(CERTS.cDate,4))

If there is such an index in the cdx Rushmore will use it regardless of the current index order. It will be a little more sluggish than having no index order at all.