>>>>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.

I apologize! Sorry you had to tell me twice. So the query is different from this other SQL button window thingy. Man, SQL Server isn't half bad. :-)