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