I'm assuming that you want to determine whether the row already exists in the table. If so, use the EXISTS() function

IF EXISTS (SELECT * FROM mytable WHERE ...)
UPDATE ...
ELSE
INSERT ...

-Mike

>I am moving data from a running system with DBF tables to SQL server. New and changed records shall be sent to the SQL database. What is the best way to select records to be updated and which records to be inserted?