表B中acout字段,数据全部是AF-GD***********
如何将AF-GD替换成GF-HD呢?
update b set acount='GF-HD'+LEFT (acount ,5)update b set acount=replace (acount, 'AF-GD','GF-HD')