自己写的一个分割字符串的函数，可以得到任意分隔符分割的字符数组（数据表表示），并且可以去除分割的时候多余的空元素。

if exists (select * from dbo.sysobjects where id = 
     object_id(N'[dbo].[SplitStr]') and xtype in (N'FN', N'IF', N'TF'))
     drop function [dbo].[SplitStr]
GO
 
create function  dbo.SplitStr(
 @String nvarchar (4000),
 @Delimiter nvarchar (10)
 )
returns  @ValueTable table ([Value] nvarchar(4000))
begin
 declare  @NextString nvarchar(4000)
 declare @Pos int
 declare @NextPos int
 declare  @CommaCheck nvarchar(1)
 
 --Initialize
 set @NextString = ''
 set  @CommaCheck = right(@String,1) 
 
 --Check for trailing Comma, if  not exists, INSERT
 --if (@CommaCheck <> @Delimiter )
 set  @String = @String + @Delimiter
 
 --Get position of first Comma
 set  @Pos = charindex(@Delimiter,@String)
 set @NextPos = 1
 
 --Loop  while there is still a comma in the String of levels
 while (@pos  <>  0)  
 begin
  set @NextString = substring(@String,1,@Pos  - 1)
  
  IF LTRIM(RTRIM(@NextString)) <> ''
  BEGIN
     insert into @ValueTable ( [Value]) Values (@NextString)
  END
   set @String = substring(@String,@pos +1,len(@String))
  
  set  @NextPos = @Pos
  set @pos  = charindex(@Delimiter,@String)
 end
 
 return
end