There is no SEEK in SQL Server. It is set based. You always get a set of rows with a SQL SELECT.
>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?
>
>Thanks
>Kev
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer