You work with a table valued UDF as a table

SELECT * FROM dbo.udfCommaListToTable(@cList) 

>I wrote this UDF which takes a comma delimited list and converts it to a table of PK's:
>
>

>CREATE FUNCTION udfCommaListToTable (@cList VARCHAR(MAX))
>RETURNS @IntKeyTable TABLE
>(IntKey INT, Counter INT PRIMARY KEY CLUSTERED ([IntKey]))
>AS
>
>BEGIN
>
>	-- Define variables
>	DECLARE @nPosition INT
>	DECLARE @cTempValue VARCHAR(MAX)
>	DECLARE @nIntKey INT
>	DECLARE @nCounter INT
>	
>	-- Set variable default values
>	SET @nCounter = 0
>	SET @cList = RTRIM(@cList)
>
>	-- If the parameter string does not end in a comma, then append
>	-- a comma to the end of the string
>	IF RIGHT(@cList, 1) <> ','
>		SET @cList = @cList + ','
>
>	
>	-- Loop while there are commas in the parameter string
>	WHILE PATINDEX('%,%', @cList) <> 0
>		BEGIN
>
>			-- Increment the counter
>			SET @nCounter = @nCounter + 1
>
>			-- Get the position of the first comma
>			SELECT @nPosition = PATINDEX('%,%', @cList)
>
>			-- Extract the value from the list
>			SELECT @cTempValue = LEFT(@cList, @nPosition - 1)
>
>			-- Convert the value to an integer
>			SET @nIntKey = CAST(@cTempValue AS INT)
>
>			-- Insert the value into the table
>			INSERT INTO @IntKeyTable
>				VALUES (@nIntKey, @nCounter)
>
>			-- Remove the comma from the string
>			SELECT @cList = STUFF(@cList, 1, @nPosition, '')
>
>		END
>
>
>RETURN
>END
>

>
>I am trying to test it:
>
>

>
>
>DECLARE @cList VARCHAR(10)
>SET @cList = '1,2,3'
>
>SELECT udfCommaListToTable(@cList) AS TList
>

>
>I get the error "'udfCommaListToTable' is not a recognized built-in function name."
>
>What am I doing wrong?