sql 中分割字符串的方法

DECLARE @str varchar(1000)
DECLARE @spliter varchar(10)
DECLARE @Num int,@Pos int, @NextPos int


set @str='123,''345''|456|879|'
set @spliter='|'
SET @Num = 0
SET @Pos = 1


WHILE(@Pos < LEN(@str))
BEGIN
SELECT @NextPos = CHARINDEX(@spliter, @str, @Pos)

IF (@NextPos = 0 OR @NextPos IS NULL)
SELECT @NextPos = LEN(@str) + 1
print SUBSTRING(@str, @Pos, @NextPos - @Pos)

SELECT @Pos = @NextPos+1
END

END