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.
Cet exercice fait partie du cours
Functions for Manipulating Data in SQL Server
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de 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 ___;