22,300
社区成员




UPDATE a
SET a.bh = REPLACE (SUBSTRING (bh,1,2),'05','06')+SUBSTRING (bh,3,LEN(bh))
WHERE SUBSTRING(bh, 1, 2) = '05'
UPDATE a
SET a.bh = '06' + CASE WHEN LEN(bh) = 2 THEN ''
ELSE LEN(bh) - 2
END
WHERE SUBSTRING(bh, 1, 2) = '05'