it can use split
DECLARE @intList VARCHAR(200) = '1,3,5,7,3,24,30' SELECT convert(INT, VALUE) FROM string_split(@intList, ',')