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
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 ___;