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 ] )
|
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: