CONCAT (Azure Stream Analytics)
Updated: April 22, 2016
Applies To: Azure
Returns a string that is the result of concatenating two or more string values.
Syntax
CONCAT ( string_value1, string_value2 [, string_valueN ] )
string_value
A string value to concatenate to the other values.
nvarchar(max)
SELECT TollId, EntryTime, CONCAT ( 'Make:', Make, ' And Model:', Model) AS MakeModel, LicensePlate FROM Input TIMESTAMP BY EntryTime WHERE Toll > 5
Show: