I have a table TblKit that has columns Id and Number. Id is primary key of type int and Number is varchar(50). The data in the table looks like this: I want to replace all the rows of KIT% with CH in the Number field. The desired output would look like: I have tried this update query: But it is

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

I have a table TblKit that has columns Id and Number. Id is primary key of type int and Number is varchar(50).

The data in the table looks like this:

Id     Number
---    ------
1      KIT001
2      KIT002 
3      DMB001
4      DM002
5      KIT003

​x
 
Id     Number---    ------1      KIT0012      KIT002 3      DMB0014      DM0025      KIT003​

I want to replace all the rows of KIT% with CH in the Number field. The desired output would look like:

Id     Number
---    ------
1      CH001
2      CH002 
3      DMB001
4      DM002
5      CH003

 
Id     Number---    ------1      CH0012      CH002 3      DMB0014      DM0025      CH003​

I have tried this update query:

UPDATE TblKit SET Number = REPLACE(Number, N'%KIT%', 'CH')

 
UPDATE TblKit SET Number = REPLACE(Number, N'%KIT%', 'CH') ​

But it is not working.

Can anyone help me regarding this?

UPDATE tblKit
SET number = REPLACE(number, 'KIT', 'CH')
WHERE number like 'KIT%'

 
UPDATE tblKitSET number = REPLACE(number, 'KIT', 'CH')WHERE number like 'KIT%'​

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

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

 
UPDATE tblKitSET number = REPLACE(number, 'KIT', 'CH')​