>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 ?

The SQL Server doesn't have concept of the record pointer. If you want to find a record you use regular select. If you want only check if record exists

IF EXISTS (SELECT * FROM mytable WHERE ...)