As Martin Smith pointed out there is also a function build in forsplitting stringssince SQL Server 2016, so there is no need for the split function:
"}},"coreNode({\"id\":\"board:SharePoint_General\"})":{"__ref":"Forum:board:SharePoint_General"},"messages({\"constraints\":{\"solution\":{\"eq\":true},\"topicId\":{\"eq\":\"message:2054596\"}},\"first\":10,\"sorts\":{\"postTime\":{\"direction\...
string = CONCATENATEX( Table1; Table1[Product]; ", "; Table1[Product]; ASC) /sdjensen Message 7 of 8 2,352 Views 0 Reply MP_123 Microsoft Employee In response to sdjensen 06-21-2016 05:00 AM it was my problem the table need to be sorted and that's the way the ...