Home
SQL Server / T-SQL
Aggregate Functions
Analytical Functions
Constraints
Cursor
Data Set
Data Type
Database
Date Timezone
Index
Insert Delete Update
Math Functions
Select Query
Sequence
Store Procedure Function
String Functions
Subquery
System
Table
Table Joins
Transact SQL
Transaction
Trigger
View
XML
CHARINDEX « String Functions « SQL Server / T-SQL
SQL Server / T-SQL
String Functions
CHARINDEX
1.
CHARINDEX: returns the starting point of the first occurrence of one string of characters within another string
2.
CHARINDEX(): find the first occurrence of a substring within another string
3.
CHARINDEX('Mars', 'The stars near Mars are far from ours')
4.
CHARINDEX: Get index of the delimiting space
5.
Combine CHARINDEX with substring