Editing something in Column Section-CodePudding

How do I edit/rename a certain section in a column?

I'm looking to change "Spanish Lab Report Card" to "Spanish Lab Report Card 2".

I'm using Microsoft SQL Server Management Studio for this project.

CodePudding user response：

In the SQL query window you would need to run a statement like the below. This would update all the records in the ReportName field with the name "Spanish Lab Report Card" to "Spanish Lab Report Card 2".

    UPDATE table_name 
    SET ReportName = 'Spanish Lab Report Card 2'
    WHERE ReportName = 'Spanish Lab Report Card'

Note this will update ALL the records with the name 'Spanish Lab Report Card' in the ReportName field.