I thought this would be useful in the future so i'm adding it...

DECLARE @LoadList as VARCHAR(MAX)
SET @LoadList = '9681549,9681554'

CREATE TABLE #LoadNumbers
(
    LoadNum int
)

DECLARE @LoadNum varchar(10), @Pos int

SET @LoadList = LTRIM(RTRIM(@LoadList))+ ','
SET @Pos = CHARINDEX(',', @LoadList, 1)

IF REPLACE(@LoadList, ',', '') <> ''
BEGIN
    WHILE @Pos > 0
    BEGIN
        SET @LoadNum = LTRIM(RTRIM(LEFT(@LoadList, @Pos - 1)))
        IF @LoadNum <> ''
        BEGIN
            INSERT INTO #LoadNumbers (LoadNum) VALUES (CAST(@LoadNum AS int)) --Use Appropriate conversion
        END
        SET @LoadList = RIGHT(@LoadList, LEN(@LoadList) - @Pos)
        SET @Pos = CHARINDEX(',', @LoadList, 1)

    END
END

SELECT * FROM #LoadNumbers

DROP TABLE #LoadNumbers