CONCAT_WS

Concatenate with separator.

Category: String Functions

Syntax

CONCAT_WS(sep, str1, [more...])

Arguments

• sep varchar Separator inserted between each concatenated string.
• str1 varchar First string value to concatenate.
• more varchar [optional | variadic] Additional string values to concatenate after str1. Optional. Can be repeated.

Returns

varchar — Returns the computed result as varchar.