SQL Server PATINDEX() Function | SQL PATINDEX
❮SQLServerFunctions[1]ExampleReturnthepositionofapatterninastring:SELECTPATINDEX(%schools%,W3Schools.com);TryitYourself»[2]DefinitionandUsageThePATINDEX()functionreturnsthepositionofapatterninastring.Ifthepatternisnotfound,thisfunctionreturns0.Note:Thesearchiscase-insensitiveandthefirstpositioninstringis1.SyntaxPATINDEX(%pattern%,string)ParameterValuesParameterDescription%pattern%Required.Thepatterntofind.ItMUSTbesurroundedby%.Otherwildcardscanbeusedinpattern,suchas:%-Matchanystringofanyleng...
❮ SQL Server Functions[1]
ExampleReturn the position of a pattern in a string:
SELECT PATINDEX(%schools%, W3Schools.com);
Try it Yourself »[2] Definition and UsageThe 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.
SyntaxPATINDEX(%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 Technical Details Works in: SQL Server (starting with 2008), Azure SQL Database,...