文件名称：sql截取中间字段
文件大小：194B
文件格式：TXT
更新时间：2015-05-15 08:56:32
sql 截取
select tables.num from (select left(stuff(shangpindata,1,charindex(',',shangpindata),''),charindex(',',stuff(shangpindata,1,charindex(',',shangpindata),''))-1) as num from orderlist) as tables 截取中间字符如“3,5,2”截取5