CREATE FUNCTION dbo.udfStringtoTable  
	( 
	@String NVARCHAR(100) ,
	@Delimiter CHAR(1)
	) 
RETURNS @Results TABLE
	(String VARCHAR(100))
AS
BEGIN

	INSERT INTO @Results
	SELECT SUBSTRING(@String+@Delimiter, n,
		CHARINDEX(@Delimiter, @String+@Delimiter, n) - n)
	FROM tally
	WHERE n <= LEN(@String)
	AND SUBSTRING(@Delimiter + @String,
				n, 1) = @Delimiter
	ORDER BY n 

	RETURN
END
GO