Sqlserver 字符串操作

UPDATE dbo.CITY SET ProvinceName=REPLACE(ProvinceName,'县','') WHERE LEN(ProvinceName)>=3  

将ProvinceName的长度大于或等于3的ProvinceName的县替换为''