Export (0) Print
Expand All
Expand Minimize

Returns the starting position of the specified expression in a character string.

CHARINDEX ( expression1 , expression2 [ , start_location ] ) 


An expression that contains the sequence of characters to be found. The expression1 argument is an expression of the ntexttype or a data type that can be implicitly converted to nvarchar.


An expression that is typically a column searched for the specified sequence. The expression2 argument is an expression of the ntext type or a data type that can be implicitly converted to nvarchar.


The character position from which to start searching for expression1 in expression2. If start_location is not given, is a negative number, or is 0, the search starts at the beginning of expression2. The start_location argument can be tinyint, smallint, int, or bigint.


The following example searches for the expression "an" from the last names of the employees in a database.

SELECT [Last Name], CHARINDEX('an', [Last Name]) AS Position
FROM Employees

This is the result set:

Last Name..............Position
Davolio           0
Fuller            0
Leverling         0
Peacock           0
Buchanan          5
Suyama            0
King              0
Callahan          7
Dodsworth         0
Hellstern         0
Smith             0
Patterson         0
Brid              0
Martin            0
Pereira           0
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2014 Microsoft