With VFP tables if I wanted to seek a record in a table I would set the index order to a index that I wish to seek on then issue the seek command to find a record, does SQL server have anything similar ? and if so could you give me some sample syntax and or some good white papers or articles on
SQL Server seek ?

Thanks
Stephen J. Hunt