CONCAT_WS

Description

Makes a concatenation of string values with others using a separator between them (CONCAT_WS in Transact-SQL).

Sample Source Pattern

Syntax

CONCAT_WS( separator, expression1, ... ,expressionN )

Arguments

separator: Separator to join.

expression1, ... ,expressionN: Expression to be found into a string.

Return Type

String value, depends on the input received.

Examples

Query

SELECT CONCAT_WS(' ', 'Mariah','Carey') AS NAME;

Result

        NAME|      
------------+
Mariah Carey|