SEEK is not necessarily faster than SQL SELECT.
>Well that's the thing. I'm running SQL squeries that should be returning one row at a time.
>
>The client gave me a table with 6000 rows. The production table has 600,000 rows, so I need to mock up the data and check it out.
>
>But that got me thinking that if I could use the index and do a seek, it would be a lot faster.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer