SQL查询结果分割多行显示

select substring(分隔的字段名+',',number,charindex(',',分隔的字段名+',',number)-number)
from 表名 ,master..spt_values s
where type='p' and number>0 and substring(','+分隔的字段名,number,1)=','