Q&A about the site for people organizing, marketing or licensing open source development projects
declare @S varchar(20) set @S = '1;2;3;44;5' while len(@S) > 0 begin print left(@S, charindex(';', @S+';')-1) set @S = stuff(@S, 1, charindex(';', @S+';'), '') end