SQL SERVER – Search Text Field – CHARINDEX vs PATINDEX | Journey to SQL Authority with Pinal Dave

We can use either CHARINDEX or PATINDEX to search in TEXT field in SQL SERVER. The CHARINDEX and PATINDEX functions return the starting position of a pattern you specify. Both functions take two arguments. With PATINDEX, you must include percent signs before and after the pattern, unless you are looking for the pattern as the… Continue Reading...

Source: SQL SERVER – Search Text Field – CHARINDEX vs PATINDEX | Journey to SQL Authority with Pinal Dave