declare @SchoolYearList nvarchar(max)='2014,2015,2016'declare @start int=1declare @length int=4create table #TempFY(SchoolYear int)while @start<len(@SchoolYearList)BEGINInsert into #TempFYselect SUBSTRINg(@SchoolYearList,@start,@length)set @start=@start+5ENDSelect SchoolYear from #TempFY



