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 valuefor 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=’
![Smile :) :)](styles/default/xenforo/smilies/smile.png)
Moved. [<img src=’/community/emoticons/emotion-1.gif’ alt=’
![Smile :) :)](styles/default/xenforo/smilies/smile.png)
]]>