CHARINDEX (Azure Stream Analytics)

Searches an expression for another expression and returns its starting position if found.

Syntax

CHARINDEX ( expressionToFind ,expressionToSearch [ , start_location ] )  

Note

The index/position for the CHARINDEX function is 1 based.

Arguments

expressionToFind

Is a character expression that contains the sequence to be found.

expressionToSearch

Is a character expression to be searched.

start_location

Is a bigint expression at which the search starts. If start_location is not specified, is a negative number, or is 0, the search starts at the beginning of expressionToSearch.

Return Types

bigint

Examples

SELECT TollId, EntryTime, CHARINDEX ( 'us', Model), Model  
FROM Input TIMESTAMP BY EntryTime  
WHERE Toll > 5  
  

Remarks

If expressionToFind is not found within expressionToSearch, CHARINDEX returns 0.