sql函數實現C#Split的功能

-- =============================================
-- Author:  <Author,,Name>
-- Create date: <Create Date,,>
-- Description:sql函數實現C#Split的功能

-- =============================================

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER   function   [dbo].[SplitStr]
(
    @SourceSql varchar(8000),-----源字串----
    @StrSeprate varchar(10)----分割符---
)
 returns float
as    
begin   
 declare @ch as int
 declare @temp as float
 set @temp = 0
 set @SourceSql= rtrim(ltrim(@SourceSql))
 set @ch=charindex(@StrSeprate,@SourceSql)
 while(@ch > 1)  
  begin  
   set @temp = @temp + convert(float,(left(@SourceSql,@ch-1)))
   set @SourceSql = substring(@SourceSql,@ch+1,(len(@SourceSql)-@ch))
   set @ch = charindex(@StrSeprate,@SourceSql)   
        end  
 return @temp
end