UPDATE dbo.CITY SET ProvinceName=REPLACE(ProvinceName,'县','') WHERE LEN(ProvinceName)>=3
将ProvinceName的长度大于或等于3的ProvinceName的县替换为''
UPDATE dbo.CITY SET ProvinceName=REPLACE(ProvinceName,'县','') WHERE LEN(ProvinceName)>=3
将ProvinceName的长度大于或等于3的ProvinceName的县替换为''