PATINDEX « String Functions « SQL Server / T-SQL






1.PATINDEX: searchs for a pattern of characters within a string
2.PATINDEX('%M_rs%', 'The stars near Mars are far from ours')