CONCAT (Azure Stream Analytics)
Returns a string that is the result of concatenating two or more string values.
Syntax
CONCAT ( string_value1, string_value2 [, string_valueN ] )
Arguments
string_value
A string value to concatenate to the other values.
Return Types
nvarchar(max)
Remarks
CONCAT implicitly converts null values to empty strings. If CONCAT receives arguments with all NULL values, it will return an empty string.
Examples
SELECT
Make,
Model,
CONCAT ( 'Make: ', Make, ', Model: ', Model) AS MakeModel
FROM Input
Make | Model | MakeModel |
---|---|---|
Contoso | QRTZX22 | Make: Contoso, Model: QRTZX22 |
See Also
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for