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: