SQL PATINDEX

UPDATE dbo.d_zhuce
SET xian1 = SUBSTRING(dizhi, PATINDEX('%市%', dizhi) + 1, PATINDEX('%县%', dizhi)
      - PATINDEX('%市%', dizhi) - 1)
WHERE (PATINDEX('%市%', dizhi) > 0) AND (PATINDEX('%市%', dizhi) < PATINDEX('%县%',
      dizhi)) AND (id < 100000) AND (PATINDEX('%县%', dizhi) > 0) AND (PATINDEX('%县%',
      dizhi) - PATINDEX('%市%', dizhi) - 1 < 4)

 

UPDATE d_shengdaima
SET areaname = REPLACE(areaname, '市', '')
WHERE (RIGHT(areaname, 1) = '市') AND (LEN(areaname) > 2)