字符串分割函数

USE [cis]
GO
/****** Object:  UserDefinedFunction [dbo].[mysplit]    Script Date: 2013/11/28 10:57:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


-- 字符串分割函数
ALTER function [dbo].[mysplit](@splitString varchar(8000), @split varchar(10))
returns @table table(substr varchar (8000))
as
begin
declare @pos int
set @pos = CHARINDEX(@split, @splitString)
while (@pos > 0)
begin
insert into @table (substr) values (SUBSTRING(@splitString, 1, @pos - 1))
set @splitString = SUBSTRING(@splitString, @pos + 1, LEN(@splitString))
set @pos = CHARINDEX(@split, @splitString)
end
insert into @table (substr) values (@splitString)
return
end