MSSQL update set進階用法一問

suen2003

我想問..如果我想set個value係
"mitsub610h sn:1234"變做"mitsubish sn:1234"
"mitsub610h sn:4567"變做"mitsubish sn:4567"
.....etc

update asset set particulars='mitsubishi' where particulars like '%mitsub610h%'
咁我上面set個part應該點改先可以做到前後唔理ge效果?係咪要create個function先做到?
thx