sql server字符串的截取方法可能很多人還不知道，下面就以一個(gè)例子來(lái)為您介紹sql server字符串截取的方法，供您參考，希望對(duì)您能有所啟迪。

已知: 字段A='F:\photo\Winter Leaves.jpg'  
要求:分段截取每段字符[字段A不能為T(mén)EXT類型,否則報(bào)錯(cuò)]
解決方法:
+++++++++++++++++++++++++++++++++++++++++++++++++++

---截取sql server字符串A的***個(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è)\后面的sql server字符串
select   reverse(left(reverse(A),charindex('/',reverse(A))-1))
輸出結(jié)果：Winter Leaves.jpg
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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

【編輯推薦】

sql server字符串函數(shù)分類詳解

sql server字符串串聯(lián)運(yùn)算符示例

SQL Server日志文件

sql server外鍵建立的寫(xiě)法

巧對(duì)sql server外鍵重命名