Why did you change the function from what I posted?

CREATE FUNCTION [dbo].[fnSplit]
(@list  VARCHAR(8000),
 @delim CHAR(1) = ','
) RETURNS TABLE AS
RETURN
   WITH csvtbl(START, stop) AS (
     SELECT START = 1,
            stop = CHARINDEX(@delim COLLATE Slovenian_BIN2, @list + @delim)
     UNION ALL
     SELECT START = stop + 1,
            stop = CHARINDEX(@delim COLLATE Slovenian_BIN2,
                             @list + @delim, stop + 1)
     FROM   csvtbl
     WHERE  stop > 0
  )
  SELECT row_number() over (order by Start) as ID, LTRIM(RTRIM(SUBSTRING(@list, START,
                      CASE WHEN stop > 0 THEN stop - START ELSE 0 END)))
         AS VALUE
  FROM   csvtbl
  WHERE  stop > 0

Note the UNION ALL part.

>>>Hmm, I like this approach using the function but I am a bit embarassed to say I am not sure what type of function that would be. Where do I put this? There are several categories under functions.
>>>
>>
>>It should be table valued inline function.
>
>
>Naomi, I get this error when I try to create the function
>

>Msg 252, Level 16, State 1, Procedure fnSplit, Line 10
>Recursive common table expression 'csvtbl' does not contain a top-level UNION ALL operator.
>

>
>Here is the function as I typed it from your post
>

>SET ANSI_NULLS ON
>GO
>SET QUOTED_IDENTIFIER ON
>GO
>
>CREATE FUNCTION [dbo].[fnSplit] 
>(
>	@list varchar(8000),
>	@delim CHAR(1) = ','
>)
>RETURNS Table
>AS
>	RETURN
>	WITH csvtbl(START, stop) AS
>	(
>		SELECT START = 1,
>			Stop = CHARINDEX(@delim COLLATE Slovenian_BIN2,
>							@list + @delim, stop + 1)
>		FROM csvtbl
>		WHERE stop > 0
>	)
>	SELECT row_number() over (order by START) AS ID, LTRIM(RTRIM(SUBSTRING(@list, START,
>								CASE WHEN stop > 0 THEN stop - START ELSE 0 END)))
>			AS VALUE
>	FROM csvtbl
>	WHERE stop > 0
>GO
>