SQL code:
<p align="center"><img title="2222222222222" height="200" alt="2222222222222" src="../UpLoadFolder/201056221026166491.gif" width="200" border="0" /></p>
有这种类型的字符串
我想把里面的 201056221026166491.gif 或者 ../UpLoadFolder/201056221026166491.gif
这样的字符串拿出来使用
应该如何写sql啊
这个还是去C#里面问正则吧,
没个具体规律,SQL难搞
SQL code:
declare @s varchar(1000)
set @s='<p align="center"><img title="2222222222222" height="200" alt="2222222222222" src="../UpLoadFolder/201056221026166491.gif" width="200" border="0" /></p>'
select LEFT(col,charindex('"',col)-1) as col from (select stuff(@s,1,charindex('../',@s)-1,'') as col) t
/*
col
------------------------------------------------
../UpLoadFolder/201056221026166491.gif
(1 行受影响)
*/
SQL code:
declare @s varchar(1000)
set @s='<p align="center"><img tit
