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

Exercise

Looking for a string within a string

If you need to check whether an expression exists within a string, you can use the CHARINDEX() function. This function returns the position of the expression you are searching within the string.

The syntax is: CHARINDEX(expression_to_find, expression_to_search [, start_location])

In this exercise, you are going to use the voters table to search for information about the voters whose names meet several conditions.

Instructions 1/3

undefined XP
  • 1

    Restrict the query to select only the voters whose first name contains the expression "dan".

  • 2

    Restrict the query to select the voters with "dan" in the first_name and "z" in the last_name.

  • 3

    Restrict the query to select the voters with "dan" in the first_name and DO NOT have the letter "z" in the last_name.