SQLSERVER字串截取

已知: 欄位A='F:\photo\Winter Leaves.jpg'   
要求:分段截取每段字元[欄位A不能為TEXT類型,否則報錯]
解決方案:
+++++++++++++++++++++++++++++++++++++++++++++++++++

---截取字串A的第一個\左邊的字串
select left(A,charindex('/',A)-1)
輸出結果：F:
++++++++++++++++++++++++++++++++++++++++++++++++++++

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

---截取最後一個\後面的字串
select   reverse(left(reverse(A),charindex('/',reverse(A))-1))
輸出結果：Winter Leaves.jpg
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

 

---截取字串A的首字幕
select   STUFF(A,1, 1, '')
輸出結果：:\photo\Winter Leaves.jpg
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++