已知: 字段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
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++