Edit

Share via

CONCAT (Azure Stream Analytics)

  • Article

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