What should I do to modify some values ​​in a field in the SQL data table?

cici16320

There is a DDD field in the data table ABC. There are a large number of data records in this field. For example, the data in it is 1,2,3,4. I want to change all 4 in this field to 1, and 3 to 2. What should I do? Thank you

fanfan1980

--try

update ABC SET DDD = CASE WHEN DDD = 4 THEN 1 WHEN DDD = 3 THEN 2 END
WHERE DDD IN (4, 3)

githzerai

update abc
set ddd = replace (ddd, '4', '1')
where charindex ('4', ddd) <> 0

update abc
set ddd = replace (ddd, '3', '2')
where charindex ('3', ddd) <> 0

kxiaper

UPDATE ABC SET DDD = REPLACE (REPLACE (DPLACE, '4', '1'), '3', '2')

潇洒的月光

update ABC
set DDD =
 case when DDD = '4' then '1'
      when DDD = '3' then '2'
      else DDD end