Function to Split Comma separated string to Integer

IF EXISTS(SELECT name FROM sys.objects WHERE name='fnSplitBigInt' AND type='TF')

DROP FUNCTION [dbo].[fnSplitBigInt] 

GO

CREATE FUNCTION [dbo].[fnSplitBigInt] 

(

    -- Add the parameters for the function here

    @input nvarchar(4000)

)

RETURNS @retBigint TABLE 

(

    [Value] [bigint] NOT NULL

)

AS

BEGIN

    DECLARE @bigint nvarchar(100)

    DECLARE @pos int

    SET @input = LTRIM(RTRIM(@input))+ ',' -- TRIMMING THE BLANK SPACES

    SET @pos = CHARINDEX(',', @input, 1) -- OBTAINING THE STARTING POSITION OF COMMA IN THE GIVEN STRING

    IF REPLACE(@input, ',', '') <> '' -- CHECK IF THE STRING EXIST FOR US TO SPLIT

    BEGIN

        WHILE @pos > 0

        BEGIN

            SET @bigint = LTRIM(RTRIM(LEFT(@input, @pos - 1))) -- GET THE 1ST INT VALUE TO BE INSERTED

            IF @bigint <> ''

            BEGIN

                INSERT INTO @retBigint (Value) 

                VALUES (CAST(@bigint AS bigint)) 

            END

            SET @input = RIGHT(@input, LEN(@input) - @pos) -- RESETTING THE INPUT STRING BY REMOVING THE INSERTED ONES

            SET @pos = CHARINDEX(',', @input, 1) -- OBTAINING THE STARTING POSITION OF COMMA IN THE RESETTED NEW STRING

        END

    END    

    RETURN

END

SELECT * FROM dbo.fnSplitbigint('12345,87612,988473')

DECLARE @xml AS XML,@str AS VARCHAR(100),@delimiter AS VARCHAR(10)
SET @str='12345,87612,988473'
SET @delimiter =','
SET @xml = CAST(('<X>'+REPLACE(@str,@delimiter ,'</X><X>')+'</X>') AS XML)
SELECT N.value('.', 'varchar(50)') AS value FROM @xml.nodes('X') AS T(N)