Find and replace column values with Microsoft SQL?

Question

I have a column called <locations>, I want to find all matching values (ex: Canada) and replace with a different value (ex: Mexico).

How do I go about that?

Thanks.

Answer 1

Like so:

update yourtable set locations = 'Mexico' where locations = 'Canada';

Answer 2

Hmm something like

UPDATE yourTable SET locations = 'Mexico' WHERE locations = 'Canada'