CHARINDEX (Azure Stream Analytics)

 

Updated: April 22, 2016

Applies To: Azure

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

Syntax

CHARINDEX ( expressionToFind ,expressionToSearch [ , start_location ] )  

System_CAPS_ICON_note.jpg Note


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

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.

bigint

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

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

Show: