SQL Server PATINDEX() Function
Clash Royale CLAN TAG#URR8PPP
<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]-->
SQL Server PATINDEX() Function
❮ SQL Server Functions
Example
Return the position of a pattern in a string:
SELECT PATINDEX('%schools%', 'W3Schools.com');Try it Yourself »
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:
|
| string | Required. The string to be searched |
Technical Details
| Works in: | SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse |
|---|
More Examples
Example
Return the position of a pattern in a string:
SELECT
PATINDEX('%s%com%', 'W3Schools.com');Try it Yourself »
Example
Return the position of a pattern in a string:
SELECT PATINDEX('%[ol]%', 'W3Schools.com');Try it Yourself »
Example
Return the position of a pattern in a string:
SELECT PATINDEX('%[z]%', 'W3Schools.com');Try it Yourself »
❮ SQL Server Functions
