Suppose you have a delimited string input that you want to split into its parts. That’s what STRING_SPLIT() does:
DECLARE @source nvarchar(max)='Canada, Cape Verde, '+ 'Central African Republic, Chad, Chile, China, Colombia, Comoros';
SELECT TRIM([value]) AS[Country]
FROM STRING_SPLIT(@source, ',');
Simple enough. But delimited lists are tricky, because the delimiter could exist in the name itself. Look for yourself what happens when we add the two Congos to the list:
Daniel has a clever solution to the problem.