Thanks for that Craig

I'm pretty familiar with VFP select commands so that difference won't worry me too much - on the other hand I always had Previous/Next to fall back on - your comments are very welcome as a guide to thinking about SQL

>Management Studio is easier to use than the old tools. I think the best thing is to get a new SQL Server 2008 book and learn things that way, then if you need to supplement for VFP, first look in the help file, then if needed, get the Hentzenwerke book.
>
>One concept that is important...you need to design applications differently. Typical VFP apps were developed where you had the enitre database available. Previous/Next buttons would move you from the first record to the last in the table. You don't work that way with SQL Server (or Oracle, MySQL, or any other C/S database). Rather, you work with a set of data. So you provide your users with a way to query data so they could say, get all customers in London. You then do a SQL SELECT and retrienve just that set of data from the server. Previous/Next buttons then operate only on the set of data that is local (all customers in London).
>
>>Looks good but is the SQL Server Management Studio issue going to confuse me?