Attached are the query plans...one that shows the index seek (when only indexed columns are included in the select statement), and the second with the table scan (a numeric column outside the index) is included in the select statement.

Thank you again for your time.

Does it make sense to you though, that the query plan would change to a table scan just because one of the 4 columns in the select is not in the index? That's the part that I'm hung up on.

P.S. The query plan with the table scan does recommend a new index... to add the "non indexed" column to a new index. But it does that for every column I add to the query, and it is unrealistic to add every column on the table to an index...