SQL里面也能用Split()

alter function split(@SourceSql varchar(8000),@StrSeprate varchar(10))
 returns @temp table(list varchar(100))
 --实现split功能 的函数
 --date    :2003-10-14
as 
begin
     declare @i int
     set @SourceSql=rtrim(ltrim(@SourceSql))
     set @i=charindex(@StrSeprate,@SourceSql)
     while @i>=1
     begin
         insert @temp values(left(@SourceSql,@i-1))
         set @SourceSql=substring(@SourceSql,@i+1,len(@SourceSql)-@i)
         set @i=charindex(@StrSeprate,@SourceSql)
     end
     if @SourceSql<>'' 
       insert @temp values(@SourceSql)
     return 
end