Splitting a string into pieces
Besides concatenating multiple row values, a common task is to split a string into pieces.
Starting with SQL Server 2016, there is a built-in function for achieving this task: STRING_SPLIT(string, separator).
This function splits the string into substrings based on the separator and returns a table, each row containing a part of the original string.
Remember: because the result of the function is a table, it cannot be used as a column in the SELECT clause; you can only use it in the FROM clause, just like a normal table.
In this exercise, you will get familiar with this function.
This exercise is part of the course
Functions for Manipulating Data in SQL Server
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
DECLARE @phrase NVARCHAR(MAX) = 'In the morning I brush my teeth. In the afternoon I take a nap. In the evening I watch TV.'
SELECT value
FROM ___;