Today, I will explain a SQL Server string function PATINDEX () used to return an integer value representing the starting position of the first occurrence of a pattern in a specified expression. This function will return zero if the pattern is not found in the specified expression.

The syntax of this function is given below.