>Charlie:
>
>This is from a MS document:
>
>"To locate a single record, only those pages of the index that are required to locate the record are sent from the server. At that point, either engine can request from the file server the page (or pages) that contains the record's actual data"
>
>That's cool!
>
>Charlie
You hit exactly the reason why SEEK/SCAN will beat SQL in so many situations.
Edward Pikman
Independent Consultant