Get startedGet started for free

Looking for a pattern within a string

If you want to search for a pattern in a string, PATINDEX() is the function you are looking for. This function returns the starting position of the first occurrence of the pattern within the string.

The syntax is: PATINDEX('%pattern%', expression)

pattern match
% any string of zero or more characters
_ any single character
[] any single character within the range specified in brackets

In this exercise, you are going to use the voters table to look at information about the voters whose names follow a specified pattern.

This exercise is part of the course

Functions for Manipulating Data in SQL Server

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

SELECT 
	first_name,
	last_name,
	email 
FROM voters
-- Look for first names that contain "rr" in the middle
WHERE ___;
Edit and Run Code