Yesterday I wrong a post on splitting string values using an Extended Function. The biggest issue with it was, unavailability in Azure SQL Database. However, we have a new function to achieve it and it works in both SQL Server 2016 and Azure SQL Database.
This is how it works;
DECLARE @String nvarchar(4000) = 'SQL,Business Intelligence,Azure'; SELECT * FROM STRING_SPLIT(@String, ',');