update [CTopicData].[dbo].[zt_SGS_ALL_s] set XK_FR_SFZH = REPLACE(XK_FR_SFZH, SUBSTRING(XK_FR_SFZH,7,3),'***') where XK_XKJG_TYSHXYDM = '11520100009400254R'
转载于:https://my.oschina.net/u/1441493/blog/1814129
update [CTopicData].[dbo].[zt_SGS_ALL_s] set XK_FR_SFZH = REPLACE(XK_FR_SFZH, SUBSTRING(XK_FR_SFZH,7,3),'***') where XK_XKJG_TYSHXYDM = '11520100009400254R'
转载于:https://my.oschina.net/u/1441493/blog/1814129