﻿ALTER FUNCTION [dbo].[CastStringToTable]
(
    @str VARCHAR(MAX)
)
RETURNS TABLE
AS
RETURN
(
    SELECT ID = T.C.value('.', 'int')
    FROM
    (
        SELECT CAST(
            '<x>' + REPLACE(@str, ',', '</x><x>') + '</x>'
            AS XML
        ) AS X
    ) A
    CROSS APPLY A.X.nodes('/x') T(C)
);
