>>I get the feeling from your reply that you would not expect to see any real difference between VFP6 and VFP9
>
>Don't really know as I said. Haven't used VFP6 in many years. I would expect it so. Someone else will probably be able to give you a true comparison.
>
>
>>We do use some SQL statements (select from where for example) within VFP and have a feeling where they are faster than Scan...endscan - I assume that working with SQL server will generally be as fast as VFP taking into account your comments about indexes
>
>As fast if not faster in many instances.
>
>
>
>>we're downloading the evaluation version of SQL Server 2005 (will this do to give us a feel?) then we'll write some sample code to test our understanding of this.
>
>Yes it should.

Thanks for all your help