ALTER FUNCTION [dbo].[CSVToTable]

(

       @psCSString VARCHAR(MAX)

)

RETURNS @otTemp TABLE(ID VARCHAR(25))

AS

BEGIN

       DECLARE @sTemp VARCHAR(10)

       WHILE LEN(@psCSString) > 0

              BEGIN

                     SET @sTemp = LEFT(@psCSString, ISNULL(NULLIF(CHARINDEX(',', @psCSString) - 1, -1), LEN(@psCSString)))

                     SET @psCSString = SUBSTRING(@psCSString,ISNULL(NULLIF(CHARINDEX(',', @psCSString), 0), LEN(@psCSString)) + 1, LEN(@psCSString))

                     INSERT INTO @otTemp VALUES (LTRIM(RTRIM(@sTemp)))

                     -- kill the nulls/ empty strings

                     DELETE FROM @otTemp WHERE Id IS NULL OR Id = ''

              END

RETURN

END