CHARINDEX

Description

Returns the index of the first occurrence of the specified value sent as a parameter when it matches (CHARINDEX in Transact-SQL).

Sample Source Pattern

Syntax

CHARINDEX( expression_to_find, expression_to_search [, start] )

Examples

Code:

IN -> SqlServer_01.sql
SELECT CHARINDEX('t', 'Customer') AS MatchPosition;

Result:

      INDEX|      
-----------+
         33|

Last updated