Something else that may not be clear in my initial post:

The select statement should return a max of one row. The table contains 5
million rows or so.

Thanks.

Rob