how to split string in sql server 2005

/****** Object:  UserDefinedFunction [dbo].[ParmsToList]    Script Date: 09/10/2008 14:19:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[ParmsToList] (@Parameters varchar(max), @delimiter varchar(10) )
returns @result TABLE (Value varchar(max))
AS  
begin
    declare @dx varchar(9)
    -- declare @loops int
     --set @loops = 0
 
     DECLARE @TempList table
          (
          Value varchar(8000)
          )
 
     if @delimiter is null  set @delimiter = ' '
     if datalength(@delimiter) < 1 set @delimiter = ' '
     set @dx = left(@delimiter, datalength(@delimiter)-1)
 
     DECLARE @Value varchar(8000), @Pos int
 
     SET @Parameters = LTRIM(@Parameters)+ @delimiter
     SET @Pos = CHARINDEX(@delimiter, @Parameters, 1)
 
     IF REPLACE(@Parameters, @delimiter, @dx) <> ''
     BEGIN
          WHILE @Pos > 0 -- AND @Loops < 100
          BEGIN
               --set @loops = @loops + 1
               SET @Value = LEFT(@Parameters, @Pos - 1)
               IF @Value <> ''
               BEGIN
                    INSERT INTO @TempList (Value) VALUES (@Value) --Use Appropriate conversion
               END
               SET @Parameters = SUBSTRING(@Parameters, @Pos+ datalength(@delimiter), 8000)
               SET @Pos = CHARINDEX(@delimiter, @Parameters, 1)
 
          END
     END    
     INSERT @result
     SELECT value
        FROM @TempList
     RETURN
END     
                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:

CREATE FUNCTION [dbo].[split]
(
	@csv nvarchar(max),
         @delim varchar(1)
)
RETURNS 
@entries TABLE 
(
	entry nvarchar(100)
)
AS
BEGIN
	DECLARE @commaindex int
	SELECT @commaindex = CHARINDEX(@delim, @csv)
	
	IF @commaindex > 0 
	BEGIN
		INSERT INTO @entries
		-- insert left side
		SELECT LTrim(RTrim(LEFT(@csv, @commaindex-1)))
		-- pass right side recursively
		UNION ALL
		SELECT entry
		FROM dbo.split(RIGHT(@csv, LEN(@csv) - @commaindex), @delim)		
	END
	ELSE
		INSERT INTO @entries
		SELECT LTrim(RTrim(@csv))
	
	RETURN
END

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31: