Last updated 1 year ago
Returns the starting position of the first occurrence of a pattern in a specified expression ().
PATINDEX( pattern, expression )
pattern: Pattern to find.
pattern
expression: Expression to search.
expression
Integer. Returns 0 if the pattern is not found.
SELECT PATINDEX( '%on%', 'No, no, non esistono più') AS [PATINDEX]
PATINDEX| ------------+ 10|