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.