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