IF EXISTS (SELECT * FROM sysobjects WHERE id=object_id(N'[dbo].[splitstring]') and type IN ( N'FN', N'IF', N'TF', N'FS', N'FT' ))
DROP FUNCTION [dbo].[splitstring]
GO

CREATE FUNCTION [dbo].[splitstring] (
	@stringToSplit	VARCHAR(MAX),
	@delimiter	CHAR(1)
)
RETURNS
	@returnList TABLE ( [idx]	int identity(1,1),
			    [Name]	[nvarchar] (500) )
AS
BEGIN
	DECLARE @name	NVARCHAR(255)
	DECLARE @pos	INT

	WHILE CHARINDEX(@delimiter, @stringToSplit) > 0
	BEGIN
		SELECT @pos  = CHARINDEX(@delimiter, @stringToSplit)
		SELECT @name = SUBSTRING(@stringToSplit, 1, @pos-1)

		INSERT INTO @returnList
		SELECT @name

		SELECT @stringToSplit = SUBSTRING(@stringToSplit, @pos+1, LEN(@stringToSplit)-@pos)
	END

	INSERT INTO @returnList
	SELECT @stringToSplit

	RETURN
END