How do I edit a column in SQL Server Management Studio

[Joe Campanini]

OK, using SELECT I can view a database record from one of my tables, but now that I can see the selected record I notice that the first name, for example, is spelt incorrectly, and I wish to manually correct this mistake. Using transact SQL how do I, or can I, instruct SQL Server Management Studio that I wish to make specified column editable. I suppose what I'm asking is, "Is there a special SELECT statement that say's select and allow manually editing of selected columns?" I suspect the answer to this is going to be so simple that you are going to say "What a bonehead...:-)"

Joe

PS I see there is a pre-defined procedure to edit the top 200 rows, but I can't see the coding associated with this, and I would like to edit a specific row.

[Uncle Dickie]

You should be able to use an UPDATE query, something like

UPDATE table_name
SET column_name = new_value
WHERE ID = ID_value