Integer List to Table

gistfile1.sql

ALTER FUNCTION [dbo].[fn_IntegerListToTable] (
	@liValues	varchar( 500 )
	
)
RETURNS
@tReturn	TABLE
(
	iID	integer
	
)
AS
BEGIN
	DECLARE
		@sInteger	varchar( 10 ) , 
		@iPosition	integer

	SET	@liValues=	LTRIM( RTRIM( @liValues ) ) + ','
	SET @iPosition=	CHARINDEX( ',' , @liValues , 1 )

	IF REPLACE( @liValues , ',' , '' ) <> ''
	BEGIN
		WHILE @iPosition > 0
		BEGIN
			SET	@sInteger=	LTRIM( RTRIM( LEFT( @liValues , @iPosition - 1 ) ) )
			IF @sInteger <> ''
			BEGIN
				INSERT INTO	@tReturn
				SELECT	CAST( @sInteger AS integer )
			END
			SET @liValues=	RIGHT( @liValues , LEN( @liValues ) - @iPosition )
			SET @iPosition=	CHARINDEX( ',' , @liValues , 1 )

		END
		
	END	
	
	RETURN	
END