STRING_SPLIT is one of the more useful T-SQL enhancements that comes with SQL Server 2016 and Azure SQL Database to split a string.
Simply it takes a string and a delimiter and splits this into rows.
SELECT * FROM STRING_SPLIT(‘sql tom ato’,’ ‘)
The results are as expected;
All newly created Azure SQL databases from June 2016 will automatically have a compatibility level of 130 as advised in this post –