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

SEEK

Kev