syscolumns names

-- =============================================
-- Author:		Bernabé Díaz
-- Create date: 12/24/2008
-- Description:	returns an array of sysname from string filter
-- =============================================
CREATE FUNCTION [dbo].[Udf_TABLECOLUMNLIST]
( 
@strDataSet VARCHAR(4000)
) 
RETURNS @DST TABLE
(
	x SYSNAME
) 
AS

BEGIN
DECLARE @Idxb INT

SET @Idxb=CHARINDEX(',',@strDataSet,1)

	IF @Idxb=0
	BEGIN
		INSERT INTO @DST
		SELECT CAST(@strDataSet AS SYSNAME)
		RETURN 
	END
	ELSE
	BEGIN
		WHILE CHARINDEX(',',@strDataSet,1)<>0
		BEGIN

			INSERT INTO @DST
			SELECT CAST(SUBSTRING(@strDataSet,1,@Idxb-1) AS SYSNAME)

			SELECT @strDataSet=LTRIM(RTRIM(SUBSTRING(@strDataSet,@Idxb+1,LEN(@strDataSet)-@Idxb)))
			SET @Idxb=CHARINDEX(',',@strDataSet,1)

		CONTINUE
		END
	END

	INSERT INTO @DST
	SELECT CAST(LTRIM(RTRIM(@strDataSet)) AS SYSNAME)

RETURN 

END