求个sql函数 - MS-SQL Server / 基础类

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