Editing something in Column Section

ktestcody 0
Viewed 31

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

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

sql-update sql-server
1 Answers

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.

MintBerryCRUNCH0
Related