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

Exercise

Extracting a substring

In this exercise, you will extract parts of a string. You will work with data from the voters table.

There is a built-in function that can help you with this task. The parameters required by this function are:

  • the expression from which the substring is extracted;
  • the starting position of the substring
  • and its length.

Keep in mind that the position of the first character in a string is 1, not 0. This will help you to correctly calculate the starting position of the substring.

Instructions 1/2

undefined XP
  • 1

    Select 5 characters from the email address, starting with position 3.

  • 2

    Extract the fruit names from the following sentence: "Apples are neither oranges nor potatoes".