>>>In the SQL Server 2005 Mgt Studio, I can open a table, change data manually, then save the results back to the database. In a was, sort of like a VFP BROWSE statement. I can do this by bringing back all rows from the table, but can I do this be bringing back only certain rows? Note that I want read/write capability, not read-only.
>>>
>>>The reason why I ask is that instead of writing a complex UPDATE statment, and possibly making a big mistake, I would like to bring back some rows make the changes manually then write them back... just like I can do with a VFP table and the BROWSE commmand.
>>
>>Sure. Just add a WHERE clause to limit the returned records. (stop the returning of all records, and then click the SQL button)
>
>Hi Fred!
>
>I don't know which TSQL statement to add the WHERE clause to? :-)
Once you "open" your table (and then stop the return of all records), click the SQL button in the upper left. That should get you a TSQL statement already set up for you. Just add your WHERE clause there.