PATINDEX('%M_rs%', 'The stars near Mars are far from ours') : PATINDEX « String Functions « SQL Server / T-SQL

1. SQL Server / T-SQL
2. String Functions
3. PATINDEX

PATINDEX('%M_rs%', 'The stars near Mars are far from ours')

1>
2> SELECT PATINDEX('%M_rs%', 'The stars near Mars are far from ours')
3> GO

-----------
         16

(1 rows affected)
1>
           
       

Related examples in the same category