Effectively Split Strings in SQL Server with the STRING_SPLIT() Function

String Split in SQL Server

STRING_SPLIT: Splitting strings into multiple rows using SQL Server using a delimiter or separator

There's A Place (Live At The BBC For "Pop Go The Beatles" / 3rd September, 1963)

There's a Bear in There (Play School Theme)

There'll Always Be an England

String Split Function in SQL Server | String_split in SQL server

SQL Query | Split concatenated string into columns | STRING_SPLIT function

new STRING_SPLIT() function in SQL Server 2016