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.
Deze oefening maakt deel uit van de cursus
Functions for Manipulating Data in SQL Server
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
SELECT
first_name,
last_name,
email
FROM voters
-- Look for first names that contain "rr" in the middle
WHERE ___;