CONCAT_WS Function in SQL

The CONCAT_WS string function in the Structured Query Language joins two or more strings in one string with the separator.

Syntax of CONCAT_WS String Function

Syntax1: This syntax uses the CONCAT_WS function with multiple columns of the SQL table:

SELECT CONCAT_WS(separator, Column_Name1, column_Name2, Column_Name3,……. Column_NameN) AS Alias_Name FROM Table_Name;