SQL2000字符串分离

做项目需要，需要把一串由"|"分割的日期字符串分离，故写了以下过程

declare @Days varchar(4000)
declare @tmpDay varchar(10)
set @Days='2006-01-12|2006-02-13|2006-03-15|2006-11-11|2003-1-1'
set @tmpDay=''
declare @i int
set @i=0
while @i<len(@Days)
begin
  set @i=@i+1
  if SUBSTRING(@Days,@i,1)='|'
     begin
       print left(@Days,@i-1)
       set @Days=SUBSTRING(@Days,@i+1,len(@Days))
       set @i=0
     end 
end
print @Days
输出结果：
2006-01-12
2006-02-13
2006-03-15
2006-11-11
2003-1-1

转载于:https://www.cnblogs.com/hgndinfo/archive/2006/06/02/2713903.html