27,579
社区成员
发帖
与我相关
我的任务
分享
--参考一下这个 。
declare @content varchar(1000)
declare @lead varchar(30), @trail varchar(30)
declare @lead_len int , @trail_len int
select @content = '前面的数据AA<div style="display:none">hiv aids organizations <a href="http://www.nav-connector.com/template/page/natural-cures-for-hiv.aspx">s</div>后s面d的f数g据h' ,
@lead = '<div style="display:none">',
@trail ='</div>'
select @lead_len = len(@lead) , @trail_len = len(@trail)
select stuff(@content,charindex(@lead,@content,1),charindex(@trail,@content,1) - charindex(@lead,@content,1) + @trail_len,'')
-----------------------------------------------
前面的数据AA后s面d的f数g据h
(1 行受影响)