I have a list of numbers like this : 1, 2, 3, 4 and so on. one way to make this list into grid with one column is union all. is there another way to do that? best regards

CodePudding user response：

You can use CROSS APPLY with STRING_SPLIT to achieve the same.

declare @table table(list varchar(50))
insert into @table values ('1, 2, 3, 4') 
select ss.value from @table as t
cross apply string_split(t.list,',') as ss