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

Compare to what?