Example
SELECT
CHARINDEX('t', 'Customer') AS MatchPosition;Definition and Usage
The CHARINDEX() function searches for a substring in a string, and returns the position.
If the substring is not found, this function returns 0.
Note
This function performs a case-insensitive search.
Syntax
CHARINDEX(
substring
,
string
,
start
)Parameter Values
| Parameter | Description |
|---|---|
| substring | Required. The substring to search for |
| string | Required. The string to be searched |
| start | Optional. The position where the search will start (if you do not want to start at the beginning of s tring ). The first position in string is 1 |
Technical Details
| Works in: | SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse |
|---|