>>>>>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
>
There's no SEEK in Sql Server.