replacing values in a collumn | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

replacing values in a collumn

how to replace all the values in collumn of a table with a different value
for example the table has a collumn called country listing the various european countries
i want to replace all the names of those european countries with a single word europe
Update yourtable set country =’Europe’ where country in (‘country1′,’country2′,etc)<br /><br />This is the forum to post workable script. Hereafter post your question at Developer Forum [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
Moved. [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />–<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />Ich unterstuetze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)
]]>