If you only want to find if a record exists, use Seek (or IndexSeek). Select will trawl through the whole table - you don't want that.
>I have a program that processes through 1,000's of records in a table and then gathers information from other tables.
>
>If I want to find out if a record (just 1) exists on one of the other tables, should I issue a SELECT statement or use SEEK to search the table - I've always preferred the SELECT - does anyone have any input on this subject? - I have speed in mind here.
>
>Thanks in advance
>Kev