>>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? :-)