SQL PATINDEX Function

The SQL Server PATINDEX is used to return the starting index position of the first occurrence of a pattern in a specified expression. If the specified string is not found, then it will return zero. The index position of the PATINDEX Function will start from 1, Not 0, and the syntax of it is SELECT … Read more