Flash cards
Review the key moves
1/4
Core idea
What is the main idea behind SQL Server PATINDEX() Function?
Lesson checks
Practice each idea before moving on
Short Mimo-style checks built from this lesson's code, terms, and sequence.
1Quick choice
Which statement best captures the main point of this lesson?
2Fill blank
Complete the missing token from the example code.
___ PATINDEX('%schools%', 'ExampleSite.com');3Order
Put the learning moves in the order that makes the concept easiest to apply.
The PATINDEX() function returns the position of a pattern in a string.
Definition and Usage
SQL Server PATINDEX() Function
Example
SELECT PATINDEX('%schools%', 'ExampleSite.com');Definition and Usage
The PATINDEX() function returns the position of a pattern in a string.
If the pattern is not found, this function returns 0.
Note
The search is case-insensitive and the first position in string is 1.
Syntax
PATINDEX(%
pattern
%,
string
)Parameter Values
| Parameter | Description |
|---|---|
| % pattern % | Required. The pattern to find. It MUST be surrounded by %. Other wildcards can be used in pattern , such as: % - Match any string of any length (including 0 length) _ - Match one single character [] - Match any characters in the brackets, e.g. [xyz] [^] - Match any character not in the brackets, e.g. [^xyz] |
| string | Required. The string to be searched |
- % - Match any string of any length (including 0 length)
- _ - Match one single character
- [] - Match any characters in the brackets, e.g. [xyz]
- [^] - Match any character not in the brackets, e.g. [^xyz]
Technical Details
| Works in: | SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse |
|---|