A bad index can give this result. With matching index expressions SQL works with the indexes to find out which records to work with, and then work with the actual tables.
>Has anyone seen a case where a corrupt index has affected SQL results?
>
>We've got a case where a client has 2 appts for the same day, yet when the lookup is run with a date filter only one shows, if no date filter is used, both show up.