---截取字符串a(chǎn)的第一個(gè)/左邊的字符串
select left(a,charindex('/',a)-1)
輸出結(jié)果：f:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

---截取/中間的字符串
select  left(stuff(a,1,charindex('/',a),''),charindex('/',stuff(a,1,charindex('/',a),''))-1)
輸出結(jié)果：photo
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

---截取最后一個(gè)/后面的字符串
select  reverse(left(reverse(a),charindex('/',reverse(a))-1))
輸出結(jié)果：winter leaves.jpg
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++