1. Learn
    2. /
  2. Courses
    3. /
  3. Functions for Manipulating Data in SQL Server
Connected

Exercise

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.

Instructions 1/2

undefined XP
  • 1

    Split the phrase declared in the variable @phrase into sentences (using the . separator).

  • 2

    Split the phrase declared in the variable @phrase into individual words.