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

See Also

• CONCAT_WS (Azure Stream Analytics)
• Substring (Azure Stream Analytics)