Delete and Update fields (data manipulation) 1

[Kenny56]

I have a table that a some bad data in it. I want to manually remove the bad data and replace it with the correct value. The corruption is only in one field so it should not be too tidius.

Could someone help me out with syntax.

I was thinking this:

Delete from Table_x where Column_x = '1';

I am not sure on the update querey.

Any help would be greatly appriciated.

 

[tlbroadbent]

Update Table_x
Set column_y = <value>
Where Column_x = '1';
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[Kenny56]

Thank you tlbroadbent,

It worked.