>>Hi
>>
>>Can anyone tell me how you would go about effectively seeking on a SQL-Server table, do you need to issue a "Select" and check the number of results.
>>
>>How about speed issues? Is Seek quicker?
>
>The fastest way to check if record or records exist in Sql Server is to use EXISTS operator.

IF EXISTS ( SELECT * FROM mytable WHERE < conditions >

Thanks, do you know what the speed differences are?

Kev