SQL Server function: string_split

select
   t.value
from
   string_split('foo,bar,baz', ',') t;
--
-- value
-- -----------
-- foo
-- bar
-- baz

select
   convert(int, t.value) as i
from
   string_split('42,99,1', ',') t
--
-- i
-- -----------
-- 42
-- 99
-- 1