转载sqlserver实现split功能 的函数

-- 实现split功能 的函数
-- date    :2005-4-20
-- Author :Domino
create   function  f_split( @SourceSql   varchar ( 8000 ), @StrSeprate   varchar ( 10 ))
returns   @temp   table (a  varchar ( 100 ))
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

select  a  from  dbo.f_split( ' A,B,C,D,E ' , ' , ' )