Thanks John.

Kev

>Kevin
>
>Relative speed will depend mostly on the server you use for SQL Server, what else is using it (is it a file server as well? Are other busy databases in there?), how busy your network is, how static your data is, how you use SEEK.
>
>In general you should feel fairly confident that SQL server will not be dismayingly slower, in many areas you should reasonably expect *visible* speed improvements. One piece of advice, pay the outrageous price to get a SQL Server "expert" to review your needs, specify hardware and help you install. You can do it all yourself but there are lots of tricks and poorly-documented tweaks that can make an unbelievable difference.
>
>If you are using indexseek then SPT using EXISTS() should allow you to achieve *very* good performance. You will not see the client cacheing that contributes so much to VFP's speed but it will be FAST. You could also consider a SP especially if you need to do lots of indexseeks at once.
>
>Summary: in my experience SQL Server is as fast or faster, as you would expect from a server-based system where I'll bet the server hardware is much better than that you used for VFP.
>
>HTH
>
>Regards
>
>JR