已知: 字段string=F:\photo\Winter Leaves.jpg 要求:分段截取每段字符[字段A不能为TEXT类型,否则报错] 解决方法: +++++++++++++++++++++++++++++++++++++++++++++++++++ ---截取字符串第一个\左边的字符串 select left(string,charindex('\',string)-1) from cs 输出结果:F: ++++++++++++++++++++++++++++++++++++++++++++++++++++ ---截取\中间的字符串 select left(stuff(string,1,charindex('\',string),''), charindex('\',stuff(string,1,charindex('\',string),''))-1) from cs输出结果:photo +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ---截取最后一个\后面的字符串 select reverse(left(reverse(string),charindex('\',reverse(string))-1)) from cs输出结果:Winter Leaves.jpg +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++