sql替换字符

declare @name varchar(100)='"acct_name"',@card varchar(100)='"id_no"' SELECT TOP 100 stuff( STUFF(Json, CHARINDEX(@name, Json) + LEN(@name) + 2, CHARINDEX(',',Json,CHARINDEX(@name, Json) + LEN(@name)) - CHARINDEX(@name, Json) - LEN(@name) - 3, replicate('*',CHARINDEX(',',Json,CHARINDEX(@name, Json) + LEN(@name)) - CHARINDEX(@name, Json) - LEN(@name) - 3) ), CHARINDEX(@card, Json) + LEN(@card) + 6, CHARINDEX(',',Json,CHARINDEX(@card, Json) + LEN(@name)) - CHARINDEX(@card, Json) - LEN(@card) - 11, replicate('*',CHARINDEX(',',Json,CHARINDEX(@card, Json) + LEN(@name)) - CHARINDEX(@card, Json) - LEN(@card) - 11) ), CHARINDEX(@name, Json) + LEN(@name) + 2, CHARINDEX(',',Json,CHARINDEX(@name, Json) + LEN(@name)) - CHARINDEX(@name, Json) - LEN(@name) - 3, CHARINDEX(@card, Json) + LEN(@card) + 6, CHARINDEX(',',Json,CHARINDEX(@card, Json) + LEN(@name)) - CHARINDEX(@card, Json) - LEN(@card) - 11, --SUBSTRING(Json, 0, CHARINDEX(@name, Json) + LEN(@name) + 2) + --REPLICATE('*', CHARINDEX(',',Json,CHARINDEX(@name, Json) + LEN(@name)) - CHARINDEX(@name, Json) - LEN(@name) - 3) --stuff Json FROM dbo.Z_UserBankInfo WHERE json IS NOT null

 

转载于:https://www.cnblogs.com/daixingqing/p/5210863.html

相关资源：SqlServer批量替换字符串工具