THE WORLD'S LARGEST WEB DEVELOPER SITE

SQL Server CHARINDEX() Function

❮ SQL Server Functions

Example

Search for "t" in string "Customer", and return position:

SELECT CHARINDEX('t', 'Customer') AS MatchPosition;
Try it Yourself »

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 string). 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

More Examples

Example

Search for "OM" in string "Customer", and return position:

SELECT CHARINDEX('OM', 'Customer') AS MatchPosition;
Try it Yourself »

Example

Search for "mer" in string "Customer", and return position (start in position 3):

SELECT CHARINDEX('mer', 'Customer', 3) AS MatchPosition;
Try it Yourself »

❮ SQL Server Functions