>>>>>>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.
Yes I know that, I mean SEEK in Fox compared to EXISTS in Sql-Server.
Kev