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