Wednesday, January 26, 2011

Find & Replace Sql-server update

UPDATE dbo.states
SET    adds = replace([city], 'Bihar', 'Jharkhand')
WHERE  adds LIKE 'Bihar%';

No comments: