CHARINDEX (SQL Server Compact)
Returns the starting position of the specified expression in a character string.
Syntax
CHARINDEX ( expression1 , expression2 [ , start_location ] )
Arguments
expression1
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.expression2
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.start_location
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.
Return Value
int
Code Example
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