SQL Server find and replace specific word in all rows of specific column

sql sql-server sql-server-2008 
UPDATE tblKit
SET number = REPLACE(number, 'KIT', 'CH')
WHERE number like 'KIT%'
  • SQLFiddle Demo

or simply this if you are sure that you have no values like this CKIT002

UPDATE tblKit
SET number = REPLACE(number, 'KIT', 'CH')
  • SQLFiddle Demo

Related

can you write a str.replace() using dictionary values in Python?
How to deploy a meteor application to my own server?
The 'await' operator can only be used within an async lambda expression
Which DATATYPE is better to use TEXT or VARCHAR?
Why can't I use alias in a count(*) "column" and reference it in a having clause?
Enum.values() vs EnumSet.allOf( ). Which one is more preferable?
Styling <a> without href attribute
URL-encoded form data is not valid
MySQL - Meaning of "PRIMARY KEY", "UNIQUE KEY" and "KEY" when used together while creating a table
PostgreSQL date() with timezone
MySQL - SELECT all columns WHERE one column is DISTINCT
How to get a particular attribute from queryset in Django in view?