update A表 set Build =replace(Build ,'座','栋') update A表 set Build =replace(Build ,'楼','栋') update A表 set Build =replace(Build ,'#公寓','栋')
大概这意思 UPDATE A SET Build = CASE WHEN CHARINDEX('座,'Build ) > 0 THEN REPLACE(Build,'座','栋') WHEN CHARINDEX('楼,'Build ) > 0 THEN REPLACE(Build,'楼','栋') WHEN CHARINDEX('#公寓'Build ) > 0 THEN REPLACE(Build,'#公寓','栋')
谢谢 csdyyr 我字符串函数太不熟悉了 怎么办哦 哭
如果前面的数字都是2位的话Update TableA Set Build = SUBSTRING(Build,1,2) + '栋'
update A表 set Build =replace(replace(replace(Build ,'#公寓','栋'),'楼','栋'),'座','栋')
update A表 set Build =replace(Build ,'座','栋')
update A表 set Build =replace(Build ,'楼','栋')
update A表 set Build =replace(Build ,'#公寓','栋')
SET Build = CASE WHEN CHARINDEX('座,'Build ) > 0 THEN
REPLACE(Build,'座','栋')
WHEN CHARINDEX('楼,'Build ) > 0 THEN
REPLACE(Build,'楼','栋')
WHEN CHARINDEX('#公寓'Build ) > 0 THEN
REPLACE(Build,'#公寓','栋')
我字符串函数太不熟悉了
怎么办哦
哭
Set Build = SUBSTRING(Build,1,2) + '栋'